Table: town_population
Columns: rank
town
population
year
borough
definition

Question: How many people live in Norton?
SQL: SELECT SUM("population") FROM town_population WHERE "town" = 'norton'

Question: Which Year has a Borough of harrogate, and a Rank smaller than 6, and a Definition of civil parish?
SQL: SELECT "year" FROM town_population WHERE "borough" = 'harrogate' AND "rank" < 6 AND "definition" = 'civil parish'

Question: Which Definition has a Rank smaller than 12, and a Town of tadcaster?
SQL: SELECT "definition" FROM town_population WHERE "rank" < 12 AND "town" = 'tadcaster'