CREATE TABLE table_79903 ("Ride name" CLOB, "Type" CLOB, "Opened in" FLOAT, "Themed land" CLOB, "Manufacturer" CLOB)

What ride was manufactured by Zierer?
SELECT "Ride name" FROM table_79903 WHERE "Manufacturer" = 'zierer'
SELECT "Ride name" FROM "table_79903" WHERE "Manufacturer" = 'zierer'