How many courses does the student with the highest GPA this semester take?
student with the highest GPA refers to student_id where MAX(gpa);
SELECT COUNT(course_id) FROM registration WHERE student_id IN ( SELECT student_id FROM student WHERE gpa = ( SELECT MAX(gpa) FROM student ) )