Name the studio for john scott
CREATE TABLE table_name_74 (studio VARCHAR, role VARCHAR)
SELECT studio FROM table_name_74 WHERE role = "john scott"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (studio VARCHAR, role VARCHAR) Question: Name the studio for john scott [/INST] SELECT studio FROM table_name_74 WHERE role = "john scott" </s>