What Director won a prize of ¥2,000,000?
CREATE TABLE table_name_42 (director_s_ VARCHAR, prize VARCHAR)
SELECT director_s_ FROM table_name_42 WHERE prize = "¥2,000,000"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (director_s_ VARCHAR, prize VARCHAR) Question: What Director won a prize of ¥2,000,000? [/INST] SELECT director_s_ FROM table_name_42 WHERE prize = "¥2,000,000" </s>