year winners score runners up notes
year
winners
score
runners up
notes
number
number number1 number2
number text score text text
1946 walsall wood 7-2 rugeley w.m.c after extra time
which team came in as runners up the most often between 1950 and 1960
WDT NN VBD IN IN NNS IN DT RBS RB IN CD CC CD
Walsall Wood
Keyword Column Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword
select c4 from w where c1_number >= 1950 and c1_number <= 1960 group by c4 order by count ( * ) desc limit 1
None None None None None Column Column Keyword Keyword None Column Literal Column Literal
c4 c4 ['sort', 'sort_desc_group_count'] ['sort', 'sort_desc_group_count'] c1_number c1_number