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 )
What about in the spring semester?
select name from student where id in ( select id from takes where semester = 'Spring' and year = 2003 )
What about in 2004?
select name from student where id in ( select id from takes where semester = 'Spring' and year = 2004 )
What course id were offered in that semester?
select distinct id from takes where semester = 'Spring' and year = 2004
What's the grade of 10838?
select grade from takes where semester = 'Spring' and year = 2004 and id = 10838