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)
names of students refers to SELECT name FROM student; taken any course in the fall semester of year 2003 refers to semester = 'Fall' AND YEAR = 2003;