I have three tables set up like the following:




The objective is to use SQL to select the titles of the courses only if the course's top scorer is in the CS Department. The student's department affiliation is in the Students table, the scores are in the Enrollments table, and the titles of the courses are in the Courses table.