Table: torrance_buses
Columns: order_year
manufacturer
model
fleet_series_quantity
powertrain_engine_transmission
fuel_propulsion

Question: how many times is the fuel propulsion is cng?
SQL: SELECT COUNT("fleet_series_quantity") FROM torrance_buses WHERE "fuel_propulsion" = 'CNG'

Question: what is the fuel propulsion where the fleet series (quantity) is 310-329 (20)?
SQL: SELECT "fuel_propulsion" FROM torrance_buses WHERE "fleet_series_quantity" = '310-329 (20)'

Question: who is the manufacturer for the order year 1998?
SQL: SELECT "manufacturer" FROM torrance_buses WHERE "order_year" = '1998'

Question: how many times is the model ge40lfr?
SQL: SELECT COUNT("manufacturer") FROM torrance_buses WHERE "model" = 'GE40LFR'

Question: how many times is the fleet series (quantity) is 468-473 (6)?
SQL: SELECT COUNT("order_year") FROM torrance_buses WHERE "fleet_series_quantity" = '468-473 (6)'

Question: what is the powertrain (engine/transmission) when the order year is 2000?
SQL: SELECT "powertrain_engine_transmission" FROM torrance_buses WHERE "order_year" = '2000'