CREATE TABLE degrees (Id VARCHAR)
CREATE TABLE campuses (Id VARCHAR)

What are the degrees conferred in 'San Francisco State University' in 2001.
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
SELECT "degrees" FROM "campuses" AS "T1" JOIN "degrees" AS "T2" ON "t1"."Id" = "t2"."campus" WHERE "San Francisco State University" = "t1"."campus" AND "t2"."year" = 2001