team winners runners-up years won years runner-up
team
winners
runners up
years won
years runner up
number
number
list length list_number
list length list_number
text number number <c,number> <c,number>
liverpool 8 3 1981, 1982, 1983, 1984, 1995, 2001, 2003, 2012 1978, 1987, 2005
which teams has the least wins ?
WDT NNS VBD-AUX DT JJS NNS .
West Ham United|Everton|Bolton Wanderers|Sunderland|Rotherham United|Rochdale|Newcastle United|Southampton|Oldham Athletic|Tranmere Rovers|Wigan Athletic|Cardiff City|Bradford City
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword
select c1 from w where c2_number = ( select min ( c2_number ) from w )
None Column None Keyword Keyword Column None
c1 ['max', 'max_min'] ['max', 'max_min'] c2_number