Table: soo_line_locomotives_4
Columns: class
wheel_arrangement
fleet_number_s
manufacturer
year_made
quantity_made
quantity_preserved

Question: What manufacturer has a year made of 1923?
SQL: SELECT "manufacturer" FROM soo_line_locomotives_4 WHERE "year_made" = '1923'

Question: What's the quantity made when the manufacturer was 4-6-2 — oooooo — pacific?
SQL: SELECT "quantity_made" FROM soo_line_locomotives_4 WHERE "manufacturer" = '4-6-2 — oooooo — pacific'

Question: What year had a quantity made of 11 and a wheel arrangement of 4-6-2?
SQL: SELECT "year_made" FROM soo_line_locomotives_4 WHERE "wheel_arrangement" = '4-6-2' AND "quantity_made" = '11'

Question: What's the quantity preserved when the fleet number was 700?
SQL: SELECT "quantity_preserved" FROM soo_line_locomotives_4 WHERE "fleet_number_s" = '700'