CREATE TABLE csu_fees (campusfee VARCHAR2, campus VARCHAR2, year VARCHAR2)
CREATE TABLE campuses (id VARCHAR2, campus VARCHAR2)

What is the campus fee of 'San Francisco State University' in year 2000?
SELECT t1.campusfee FROM csu_fees AS t1 JOIN campuses AS t2 ON t1.campus = t2.id WHERE t2.campus = "San Francisco State University" AND t1.year = 2000
SELECT "t1"."campusfee" FROM "csu_fees" "t1" JOIN "campuses" "t2" ON "San Francisco State University" = "t2"."campus" AND "t1"."campus" = "t2"."id" WHERE "t1"."year" = 2000