4.16

Write an SQL query using the university schema to find the ID of each student who has never taken a course at the university. Do this using no subqueries and no set operations (use an outer join).

---

SELECT s.ID
FROM student s LEFT OUTER JOIN takes t
    ON s.ID = t.ID
WHERE t.ID IS NULL;