Table: fire_brigades
Columns: brigade
type
pumpers
tankers
slip_ons
cars
hazmat

Question: What is the Brigade, when the Type is Rural, and when the value for Tankers is 1?
SQL: SELECT "brigade" FROM fire_brigades WHERE "type" = 'rural' AND "tankers" = 1

Question: What is the Hazmat, when the Type is Rural, and when the number of Tankers is 1?
SQL: SELECT "hazmat" FROM fire_brigades WHERE "type" = 'rural' AND "tankers" = 1