Table: citrus_fleet
Columns: fleet
year
manufacture
model
length_ft
engine
transmission

Question: What year had an Allison B400R transmission and a model of BRT?
SQL: SELECT "year" FROM citrus_fleet WHERE "transmission" = 'Allison B400R' AND "model" = 'BRT'

Question: What is the fleet number when the length (ft) is 30?
SQL: SELECT "fleet" FROM citrus_fleet WHERE "length_ft" = 30

Question: What is the fleet number when the transmission is Voith D863.4 and the engine is Cummins ISL?
SQL: SELECT "fleet" FROM citrus_fleet WHERE "transmission" = 'Voith D863.4' AND "engine" = 'Cummins ISL'

Question: Which year had a transmission of Voith D863.4 and a Cummins ISM engine?
SQL: SELECT "year" FROM citrus_fleet WHERE "transmission" = 'Voith D863.4' AND "engine" = 'Cummins ISM'