party leader from to
party
leader
from
to
number parsed year month
number parsed year month
text text date date
scottish national party gordon wallace may 1974 may 1978
compare the scottish national party to the conservative and determine which party had their leaders in office for a longer time .
VB DT NNP NNP NNP TO DT JJ CC VB WDT NN VBD-AUX PRP$ NNS IN NN IN DT JJR NN .
Conservative
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Literal.String Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Column Keyword Keyword Keyword Keyword
select c1 from w where c1 in ( 'scottish national party' , 'conservative' ) group by c1 order by sum ( c4_year - c3_year ) desc limit 1
Keyword None Literal Literal Literal Keyword None Literal None None None Column None None None Column Column None None Keyword None None
['conj', 'conj_or'] ['conj', 'conj_or'] c1 c3_year c3_year ['sort', 'sort_desc_group']