rank city population (2011) population (2001) state/territory
rank
city
population -lrb- 2011 -rrb-
population -lrb- 2001 -rrb-
state\\/territory
number
first second
number
number
number text(text) number number text
1 trivandrum (thiruvananthapuram) 12478447 11978450 maharashtra
list each of the cities who have more than 1,000,000 in population from the state/territory of punjab .
NN DT IN DT NNS WP VBD-AUX JJR IN CD IN NN IN DT NN IN NNP .
Ludhiana|Amritsar
select c2 from w where c3_number > 1000000 and c5 = 'punjab'