Table: fire_stations
Columns: station_number
district
location
type
appliances
registrations

Question: what is the total number of location where station number is c03
SQL: SELECT COUNT("location") FROM fire_stations WHERE "station_number" = 'C03'

Question: what are all the type where station number is c08
SQL: SELECT "type" FROM fire_stations WHERE "station_number" = 'C08'

Question: what are all the type where location is st ives, cambridgeshire
SQL: SELECT "type" FROM fire_stations WHERE "location" = 'St Ives, Cambridgeshire'

Question: what are all the registrations where station number is c26
SQL: SELECT "registrations" FROM fire_stations WHERE "station_number" = 'C26'

Question: what are all the location where station number is c11
SQL: SELECT "location" FROM fire_stations WHERE "station_number" = 'C11'

Question: what are all the registrations where location is yaxley
SQL: SELECT "registrations" FROM fire_stations WHERE "location" = 'Yaxley'