What are the ids of students who took courses in the Fall of 2003?
select id from takes where semester = 'Fall' and year = 2003
What are their names?
select name from student where id in (select id from takes where semester = 'Fall' and year = 2003)