What course id were offered in that semester?
SELECT distinct id FROM takes WHERE semester   =   'Spring' AND YEAR   =   2004
course id refers to id; offered in that semester refers to filtering by a specific semester and year; distinct is used to avoid duplicates.