sqlzoo答案—Using NULL

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

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.

SELECT teacher.name, dept.name
 FROM teacher INNER JOIN dept
           ON (teacher.dept=dept.id)

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

SELECT teacher.name, dept.name FROM teacher
LEFT JOIN dept
ON teacher.dept = d