Table: fire_stations_2
Columns: station_number
district
location
type
appliances
registrations

Question: What is the station number of the station at Dogsthorpe?
SQL: SELECT "station_number" FROM fire_stations_2 WHERE "location" = 'dogsthorpe'

Question: What is the type of the station with a 1 wrl appliance in Linton?
SQL: SELECT "type" FROM fire_stations_2 WHERE "appliances" = '1 wrl' AND "location" = 'linton'

Question: What is the appliance at the station in St Neots?
SQL: SELECT "appliances" FROM fire_stations_2 WHERE "location" = 'st neots'

Question: What is the registration of the station at Cambridge?
SQL: SELECT "registrations" FROM fire_stations_2 WHERE "district" = 'cambridge'

Question: What is the location of the station at Huntingdonshire with a station number of c17?
SQL: SELECT "location" FROM fire_stations_2 WHERE "district" = 'huntingdonshire' AND "station_number" = 'c17'

Question: What is the registration of the station with a retained type and a station number of c03?
SQL: SELECT "registrations" FROM fire_stations_2 WHERE "type" = 'retained' AND "station_number" = 'c03'