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

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')