如何用sql语句查询黄同学不学的课程号

假设学生表为students，课程表为courses，选课表为selections，可使用以下SQL语句查询黄同学不学的课程号：

SELECT course_id FROM courses WHERE course_id NOT IN ( SELECT course_id FROM selections WHERE student_id = ( SELECT student_id FROM students WHERE student_name = '黄同学' ) );