human
Schema:
city (City_ID, Official_Name, Status, Area_km_2, Population, Census_Ranking)
farm (Farm_ID, Year, Total_Horses, Working_Horses, Total_Cattle, Oxen, Bulls, Cows, Pigs, Sheep_and_Goats)
farm_competition (Competition_ID, Year, Theme, Host_city_ID, Hosts)
competition_record (Competition_ID, Farm_ID, Rank)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me the names of all the cities.
assistant
SELECT official_name FROM city;
human
Tell me the city status of 'Grand Falls/Grand-Sault'.
assistant
SELECT status FROM city WHERE official_name = 'Grand Falls/Grand-Sault';
human
Which of the cities are not towns?
assistant
SELECT official_name FROM city WHERE status != 'Town';
human
Which city status is the most common?
assistant
SELECT Status FROM city GROUP BY Status ORDER BY COUNT( * ) DESC LIMIT 1 ;