What ride was manufactured by Zierer?
CREATE TABLE table_name_43 (ride_name VARCHAR, manufacturer VARCHAR)
SELECT ride_name FROM table_name_43 WHERE manufacturer = "zierer"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (ride_name VARCHAR, manufacturer VARCHAR) Question: What ride was manufactured by Zierer? [/INST] SELECT ride_name FROM table_name_43 WHERE manufacturer = "zierer" </s>