CREATE TABLE student (name VARCHAR, id VARCHAR, semester VARCHAR, YEAR VARCHAR)
CREATE TABLE takes (name VARCHAR, id VARCHAR, semester VARCHAR, YEAR VARCHAR)

Find the names of students who have taken any course in the fall semester of year 2003.
SELECT name FROM student WHERE id IN (SELECT id FROM takes WHERE semester = 'Fall' AND YEAR = 2003)
SELECT "name" FROM "student" WHERE "id" IN (SELECT "id" FROM "takes" WHERE "YEAR" = 2003 AND "semester" = 'Fall')