How many courses do not have a prerequisite?
select count ( * ) from course where course_id not in ( select course_id from prereq )
Which of those courses has the most number of credits?
select * from course where course_id not in ( select course_id from prereq ) order by credits desc limit 1
How many courses are there?
select count ( * ) from course