文章目录
-
- 原题题目
- 代码实现(首刷自解)
原题题目
代码实现(首刷自解)
# Write your MySQL query statement below
SELECT id,name
FROM students s
WHERE s.department_id not IN (SELECT id FROM departments)
# Write your MySQL query statement below
SELECT id,name
FROM students s
WHERE s.department_id not IN (SELECT id FROM departments)