sqlzoo习题答案--Using Null

最新推荐文章于 2022-07-30 20:22:46 发布

codema

最新推荐文章于 2022-07-30 20:22:46 发布

阅读量479

点赞数

分类专栏： MySql

本文链接：https://blog.csdn.net/codema/article/details/80770281

版权

本文提供了解决SQLZOO中关于使用COALESCE函数处理NULL值的习题答案，重点关注如何在教师移动电话号码缺失时显示默认值'07986 444 2266'，展示教师姓名及其手机号码或默认值。

摘要由CSDN通过智能技术生成

5.Use COALESCE to print the mobile number. Use the number '07986 444 2266' if there is no number given.Show teacher name and mobile number or '07986 444 2266'

select name,coalesce(mobile,'07986 444 2266')as mobile from teacher

6.Use the COALESCE function and a LEFT JOIN to print the teacher name and department name.Use the string 'None' where there is no department.

select teacher.name,coalesce(dept.name,'None')as department
from teacher left join dept
on teacher.dept=dept.id

8.Use COUNT and GROUP BY dept.name to show each department and the number of staff. Use a RIGHT JOIN to ensure that the Engineering department is listed.