Table: city_demographics
Columns: city
population
registered_voters
democratic
republican
d_r_spread
other
no_party_preference

Question: What is the population if the city is Gilroy?
SQL: SELECT "population" FROM city_demographics WHERE "city" = 'Gilroy'

Question: If Democratic is 42.5%, what is the city?
SQL: SELECT "city" FROM city_demographics WHERE "democratic" = '42.5%'

Question: If the registered voters is 66.8%, what is the minimum population?
SQL: SELECT MIN("population") FROM city_demographics WHERE "registered_voters" = '66.8%'

Question: What is the other is the city is Los Gatos?
SQL: SELECT "other" FROM city_demographics WHERE "city" = 'Los Gatos'

Question: What is the d-r spread if the no party preference is 31.8%?
SQL: SELECT "d_r_spread" FROM city_demographics WHERE "no_party_preference" = '31.8%'

Question: If the city is Santa Clara, what is the population total number?
SQL: SELECT COUNT("population") FROM city_demographics WHERE "city" = 'Santa Clara'