链接:https://sqlzoo.net/wiki/Using_Null
SELECT name
FROM teacher
WHERE dept IS NULL
SELECT teacher.name, dept.name
FROM teacher INNER JOIN dept
ON (teacher.dept=dept.id)
SELECT teacher.name, dept.name FROM
teacher LEFT JOIN dept ON teacher.dept=dept.id
SELECT teacher.name, dept.name FROM
teacher RIGHT JOIN dept ON teacher.dept=dept.id
SELECT teacher.name, COALESCE(teacher.mobile,'07986 444 2266')
FROM teacher
SELECT teacher.name, COALESCE(dept.name, 'None') FROM
teacher LEFT JOIN dept ON teacher.dept=dept.id
SELECT COUNT(teacher.id), COUNT(teacher.mobile)
FROM teacher
SELECT dept.name, COUNT(teacher.dept) FROM
dept LEFT JOIN teacher ON dept.id=teacher.dept
GROUP BY dept.name
SELECT name,
(CASE WHEN dept IN (1,2) THEN 'Sci' ELSE 'Art' END)
FROM teacher
SELECT name,
(CASE WHEN dept IN(1,2) THEN 'Sci'
WHEN dept =3 THEN 'Art'
ELSE 'None'
END)
FROM teacher