How many courses that do not have prerequisite?
create table prereq (course_id varchar, PRIMARY KEY (course_id)); create table course (course_id varchar, PRIMARY KEY (course_id))
select count(*) from course where not course_id in (select course_id from prereq)