rank city population area
(km2) density
(inhabitants/km2) altitude
(mslm)
rank
city
population
area -lrb- km2 -rrb-
density -lrb- inhabitants\\/km2 -rrb-
altitude -lrb- mslm -rrb-
number
number
number
number
number
rank text number number number number
1st alessandria 94191 203.97 461.8 95
how many cities do not have lower populations than valenza ?
WRB JJ NNS VBD-AUX RB VBD-AUX JJR NNS IN NNP .
5
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword
select count ( c2 ) from w where c2 != 'valenza' and c3_number >= ( select c3_number from w where c2 = 'valenza' )
Keyword Keyword Column None Keyword None Keyword Column Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['conj', 'conj_and'] ['conj', 'conj_and'] c3_number ['conj', 'conj_and']