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
which leader served more years , william leslie , or joyce shannon ?
WDT NN VBD JJR NNS , NNP NNP , CC NNP NNP .
William Leslie
select c2 from w where c2 in ( 'william leslie' , 'joyce shannon' ) order by c4_year - c3_year desc limit 1