What are the degrees conferred in "San Francisco State University" in 2001.
CREATE TABLE degrees (Id VARCHAR); CREATE TABLE campuses (Id VARCHAR)
SELECT degrees FROM campuses AS T1 JOIN degrees AS T2 ON t1.id = t2.campus WHERE t1.campus = "San Francisco State University" AND t2.year = 2001
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE degrees (Id VARCHAR); CREATE TABLE campuses (Id VARCHAR) Question: What are the degrees conferred in "San Francisco State University" in 2001. [/INST] SELECT degrees FROM campuses AS T1 JOIN degrees AS T2 ON t1.id = t2.campus WHERE t1.campus = "San Francisco State University" AND t2.year = 2001 </s>