rank urban area population
(2001 census) area (km2) density (people/km2) major subdivisions metropolitan area
rank
urban area
population -lrb- 2001 census -rrb-
area -lrb- km ² -rrb-
density -lrb- people\\/km ² -rrb-
major subdivisions
metropolitan area
number
list length
number
number
number
list length
number <f, text> number number number <c, text> text
1 greater glasgow 1,168,270 368.47 3,171.0 glasgow, paisley, coatbridge, clydebank, motherwell, wishaw glasgow
how many urban areas have a population above 90,000 ?
WRB JJ JJ NNS VBD-AUX DT NN IN CD .
5
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3_number > 90000
Keyword Keyword Column Column None None Column Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c2 c3_number ['comp', 'comp_greater']