SQLZOO Using_Null 答案

题目网址：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 name, COALESCE(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(name),count(mobile)
from teacher

select dept.name,count(teacher.name)
from teacher right join dept on teacher.dept=dept.id
group by dept.name

select name,
  case when dept=1 or dept=2
       then 'Sci'
       else 'Art'
  end
from teacher

select name,
  case when dept=1 or dept=2
       then 'Sci'
       when dept=3
       then 'Art'
       else 'None'
  end
from teacher