# name office political party occupation
#
name
office
political party
occupation
number
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
number text timespan text text
1 ole olsen strømme 1886-1901 liberal party church bell ringer
how many mayors were in office for a total of 9 years ?
WRB JJ NNS VBD-AUX IN NN IN DT NN IN CD NNS .
2
select count ( c2 ) from w where c3_maximum_year - c3_minimum_year = 9