town/village population postal code municipality island location
town\\/village
population
postal code
municipality
island
location
number
text number text text text text
akrar 28 fo 927 sumbiar suðuroy 61°27′20′′n 6°45′33′′w﻿ / ﻿61.45556°n 6.75917°w
how many towns or villages have a population of at least 5 but less than 10 ?
WRB JJ NNS CC NNS VBD-AUX DT NN IN IN JJS CD CC JJR IN CD .
6
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select count ( c1 ) from w where c2_number >= 5 and c2_number < 10
Keyword Keyword Column Column Column None None Column None Keyword Keyword Literal None Keyword Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c1 c1 c1 c2_number ['comp', 'comp_gequal'] ['comp', 'comp_gequal'] ['comp', ''] ['comp', '']