What are the names of all students who took any course in the fall semester of the year 2003?
SELECT name FROM student WHERE id IN  ( SELECT id FROM takes WHERE semester   =   'Fall' AND YEAR   =   2003 ) 
names of all students who took any course refers to SELECT name FROM student; fall semester of the year 2003 refers to semester = 'Fall' AND YEAR = 2003;