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 schools left the genesee county b league before ainsworth ?
WRB JJ NNS VBD DT NNP NNP NNP NNP IN NNP .
7
select count ( c1 ) from w where c4_list_number < ( select c4_list_number from w where c1 = 'ainsworth' )