CREATE TABLE student (name VARCHAR2, id VARCHAR2)
CREATE TABLE takes (id VARCHAR2, course_id VARCHAR2)
CREATE TABLE course (course_id VARCHAR2, dept_name VARCHAR2)

Find the name of students who didn't take any course from Biology department.
SELECT name FROM student WHERE NOT id IN (SELECT T1.id FROM takes AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.dept_name = 'Biology')
WITH "_u_0" AS (SELECT "T1"."id" FROM "takes" "T1" JOIN "course" "T2" ON "T1"."course_id" = "T2"."course_id" AND "T2"."dept_name" = 'Biology' GROUP BY "id") SELECT "name" FROM "student" LEFT JOIN "_u_0" "_u_0" ON "_u_0"."" = "id" WHERE "_u_0"."" IS NULL