from to name party position
from
to
name
party
position
number
number
number number text text text
1850 1862 m. borgarelli d'ison se colonel of infantry e.r
how many different mayors served between 1970 and 2010 ?
WRB JJ JJ NNS VBD IN CD CC CD .
3
Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select count ( distinct c3 ) from w where c2_number >= 1970 and c1_number <= 2010
Keyword Keyword Keyword Column None Column Literal Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['conj', 'conj_or'] c3 c1_number c1_number