Table: ted
Columns: name
built
wheels
fuel_trans
status
colour

Question: What sort of Fuel/Trans does the Grey & Red locomotive have?
SQL: SELECT "fuel_trans" FROM ted WHERE "colour" = 'grey & red'

Question: What is the status of the Cub/John locomotive?
SQL: SELECT "status" FROM ted WHERE "name" = 'the cub/john'

Question: What is the manufacturer, found under the Built column, that made locomotives with a Fuel/Trans of diesel-electric?
SQL: SELECT "built" FROM ted WHERE "fuel_trans" = 'diesel-electric'

Question: What is found in the Built column of the locomotive with 0-4-0 wheels that is still in service?
SQL: SELECT "built" FROM ted WHERE "wheels" = '0-4-0' AND "status" = 'in service'

Question: What is the color of the locomotive built by Minirail 1954?
SQL: SELECT "colour" FROM ted WHERE "built" = 'minirail 1954'