name club position years current status international caps
name
club
position
years
current status
international caps
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
number
text text text timespan text number
frank farina sydney fc fw 1982-83 coaching 67
the team with the largest number of caps after 1988
DT NN IN DT JJS NN IN NNS IN CD
Dinamo Zagreb
Keyword Column Keyword Keyword Keyword Column Keyword Literal.Number Keyword Keyword Column Keyword Keyword Keyword
select c2 from w where c4_maximum_year > 1988 order by c6_number desc limit 1
None Column None Keyword Keyword Keyword Keyword Column Column Literal
c2 ['sort', 'sort_desc'] ['sort', 'sort_desc'] ['sort', 'sort_desc'] ['sort', 'sort_desc'] c6_number c4_maximum_year