SQLZOO Using Null 参考答案（含表格样式和解题思路）

1. List the teachers who have NULL for their department.

思路：这个题是简单查询
考点：测定空值用 IS NULL 而不是 = NULL

SELECT name
FROM teacher
WHERE dept IS NULL

2. Note the INNER JOIN misses the teachers with no department and the departments with no teacher.

思路：INNER JOIN 就是求交集，会去掉含有空值行

SELECT t.name, de.name
FROM Teacher t INNER JOIN dept de
ON t.dept=de.id

3.Use a different JOIN so that all teachers are listed.

思路：用TEACHER表作为主表连接（想要哪个显示all 就用哪个作为主表）
考点：RIGHT JOIN & LEFT JOIN

SELECT t.name ,de.name
FROM teacher t LEFT