CREATE TABLE table_name_43 (ride_name VARCHAR2, manufacturer VARCHAR2)

What ride was manufactured by Zierer?
SELECT ride_name FROM table_name_43 WHERE manufacturer = "zierer"
SELECT "ride_name" FROM "table_name_43" WHERE "manufacturer" = "zierer"