What is the population of city Id 2?
select population from city where city_id = 2
What is the census ranking of Perth-Andover?
select census_ranking from city where official_name = "Perth-Andover"
What is the name of hosts of Carnival M is back?
select hosts from farm_competition where theme like "%carnival m is back%"