Which Of The Following Should Be Used To Find All The Courses #108

Select distinct course_id from instructor where name not in (’Fall’, ’Spring’);

Select course id from section where semester = 'Spring' and year= 2010); 

Select count (distinct ID) from takes where (course id, sec id, semester, year) in (select course id, sec id, semester, year from teaches where teaches.ID= 10101);