Table: bus_specs
Columns: length_feet
year
make_and_model
floor_type
number_of_seats
bicycle_capacity
fuel_propulsion
quantity

Question: How many seats in 2001 with a quantity greater than 4?
SQL: SELECT COUNT("number_of_seats") FROM bus_specs WHERE "year" = '2001' AND "quantity" > 4

Question: What make and model of the diesel vehicle with a high floor type, bike capacity less than 3, and a quantity of 4?
SQL: SELECT "make_and_model" FROM bus_specs WHERE "fuel_propulsion" = 'diesel' AND "floor_type" = 'high' AND "bicycle_capacity" < 3 AND "quantity" = 4