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
most number of credits refers to MAX(credits); courses not having prerequisites refers to course_id NOT IN (SELECT course_id FROM prereq);