What about in 2004?
SELECT name FROM student WHERE id IN  ( SELECT id FROM takes WHERE semester   =   'Spring' AND YEAR   =   2004 ) 
in 2004 refers to YEAR = 2004; student names who are taking courses in a specific semester and year refers to joining information between student and takes tables based on student id;