category area
(sq miles) area
(km2) population
(2011) density
(per km2)
category
area -lrb- sq miles -rrb-
area -lrb- km2 -rrb-
population -lrb- 2011 -rrb-
density -lrb- per km2 -rrb-
number
number
number
number
text text number number number number
mainland aberdeen city 70 182 222800 1224
what number of mainlands have populations under 100,000 ?
WDT NN IN NNS VBD-AUX NNS IN CD .
9
select count ( * ) from w where c1 = 'mainland' and c5_number < 100000