Table: steam_locomotives_ir
Columns: class
type
names
quantity_made
manufacturer
date_made

Question: What is the date of the locomotive with a Waterford class?
SQL: SELECT "date_made" FROM steam_locomotives_ir WHERE "class" = 'waterford'

Question: What is the date of the locomotive named Blacklion Glencar?
SQL: SELECT "date_made" FROM steam_locomotives_ir WHERE "names" = 'blacklion glencar'

Question: What is the quantity made of the locomotive with a Waterford class?
SQL: SELECT "quantity_made" FROM steam_locomotives_ir WHERE "class" = 'waterford'

Question: What is the class of the locomotive with a quantity made of 1 and a 0-6-0t type?
SQL: SELECT "class" FROM steam_locomotives_ir WHERE "quantity_made" = '1' AND "type" = '0-6-0t'

Question: What is the class of the locomotive with a 0-4-0st type?
SQL: SELECT "class" FROM steam_locomotives_ir WHERE "type" = '0-4-0st'

Question: What is the name of the locomotive with a Glencar class?
SQL: SELECT "names" FROM steam_locomotives_ir WHERE "class" = 'glencar'