Table: railcar_specs
Columns: number_range
introduced
builder
engine
weight_long_tons
seats
withdrawn
notes

Question:  what's the engine where builder is gloucester rcw and withdrawn is 1959
SQL: SELECT "engine" FROM railcar_specs WHERE "builder" = 'Gloucester RCW' AND "withdrawn" = '1959'

Question:  what's the engine where number range is 8–9, 13–16
SQL: SELECT "engine" FROM railcar_specs WHERE "number_range" = '8–9, 13–16'

Question:  what's the introduced where notes is 9 withdrawn in 1946 after fire
SQL: SELECT "introduced" FROM railcar_specs WHERE "notes" = '9 withdrawn in 1946 after fire'

Question:  what's the builder where withdrawn is 1954–1958
SQL: SELECT "builder" FROM railcar_specs WHERE "withdrawn" = '1954–1958'

Question:  what's the notes where number range is 17
SQL: SELECT "notes" FROM railcar_specs WHERE "number_range" = '17'

Question:  what's the notes where withdrawn is 1956–57
SQL: SELECT "notes" FROM railcar_specs WHERE "withdrawn" = '1956–57'