high school join
year from left league left to
high school
join year
from
left
league left to
list length list_number
list length list_number
list length
text <n,number> text <n,number> <n,text>
ainsworth 1954 county c league 1961 big nine conference
how many high schools had a league leave to big nine conference ?
WRB JJ JJ NNS VBD-AUX DT NN NN TO JJ CD NN .
8
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( c1 ) from w where c5 = 'big nine conference'
Keyword Keyword Column Column None None Column Column Column Literal Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c1 c1 c5 c5 c5