1. Is the query answering the question it's associate with?
2. Is a subquery is necessary to answer the question that is posed?

Query: https://pastebin.com/T3Mb3RgL

Which students in CIS courses haven't completed any assignments for a CIS class (schedule)?

SELECT * FROM Students WHERE studentid IN

(SELECT studentid FROM Enrollments WHERE enrollmentID NOT IN

(SELECT enrollmentID FROM StudentWork)

AND scheduleID IN

(SELECT scheduleID FROM Schedules WHERE courseID IN

(SELECT courseID FROM Courses WHERE Department='CIS')))

Which courses are offered in only a single campus?

SELECT * FROM Courses WHERE courseid IN

(SELECT CourseID FROM Schedules WHERE RoomID IN

(SELECT RoomID FROM roomsWHERE BuildingID IN

(SELECT BuildingID FROM Buildings GROUP BY CampusID HAVING Count(DISTINCT campusid) > 1)))