sqlzoo习题答案--Using Null

最新推荐文章于 2022-07-30 20:22:46 发布
最新推荐文章于 2022-07-30 20:22:46 发布
阅读量473 收藏
点赞数
分类专栏： MySql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：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. 
select dept.
最低0.47元/天 解锁文章
codema
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
sqlzoo - Using Null 答案
DataScience成长之路
10-12 2150
http://zh.sqlzoo.net/wiki/Using_Null List the teachers who have NULL for their department. SELECT name FROM teacher WHERE dept IS NULL /* 这里不能使用dept = '' 或者 dept = NULL*/ Note the INNER JOIN misse...
SQLZOO Using Null 参考答案（含表格样式和解题思路）
MRmaand12的博客
05-04 407
List the teachers who have NULL for their department. 思路：这个题是简单查询 考点：测定空值用 IS NULL 而不是 = NULL SELECT name FROM teacher WHERE dept IS NULL Note the INNER JOIN misses the teachers with no departmen...
SQLZOO Using_Null 答案
m0_38093099的博客
04-25 210
题目网址：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 ...
sqlzoo练习答案--Using Null
非淡泊无以明志，非宁静无以致远
08-07 418
teacher id dept name phone mobile 101 1 Shrivell 2753 07986 555 1234 102 1 Throd 2754 07122 555 1920 103 1 Splint 2293   104   Spiregra
SQLZOO练习题答案参考（全）
m0_50871079的博客
07-30 3187
自学SQL将近一年，比较有名的SQL题库都尝试刷过，一边刷高阶题，一边会回头复盘，尝试多种解法，因此不定时分享刷过的题库的参考解法，第一篇是SQL_ZOO
SQLzoo 习题记录08-Using Null & Quiz
Moist_Grass的博客
06-14 310
Using Null 网址：Using Null - SQLZOO
【练习篇】SQLZOO习题答案_Using Null
精灵少女的博客
10-27 391
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 FULL JOIN d.
[SQL]sqlzoo练习题Using Null
weixin_49237757的博客
03-04 297
【SQL】sqlzoo练习题Using Null 所用到的表 1. 1.列出學系department是NULL值的老師 select t.name from teacher t left join dept d on t.dept=d.id where t.dept is null 2.inner join 的使用，内连接只取两个表的交集 3.使用不同的JOIN(外連接)，來列出全部老師。(列出所有老师的名字和对应的系名称) 4.使用不同的JOIN(外連接)，來列出全部學系。 5.查询教师姓名，电话
SQLZOO (NULL) 答案
weixin_43745631的博客
02-16 364
List the teachers who have NULL for their department. SELECT name FROM teacher WHERE dept IS NULL Note the INNER JOIN misses the teachers with no department and the departments with no teacher...
SQLZOO: Using Null--COALESCE( )
起床了
05-02 331
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 2...
SQLZOO:Using Null 笔记
weixin_43898956的博客
04-19 143
Using Null teacher表与dept表： The school includes many departments. Most teachers work exclusively for a single department. Some teachers have no department. 1、List the teachers who have NULL for their ...
SQL ZOO练习——Using Null
一个好学生_叶纪杉
08-07 1704
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 teach...
SQLZOO USING NULL
bestallen的博客
01-03 1446
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 tea
SQLzoo练习题 8 NULL值
WANG_Qing_qiu的博客
11-12 1257
8 NULL值 NULL, INNER JOIN, LEFT JOIN, RIGHT JOIN1. 1. 列出學系department是NULL值的老師。為何不能用 =。你可能會以為 dept=NULL 是可行的，但它不是。你要使用dept IS NULL select name from teacher where dept is null ***2.注意INNER JOIN 不理會沒有學系...
sqlzoo答案参考
热门推荐
weijiahui_的博客
04-09 1万+
select basics1.Modify it to show the population of Germanyselect population from world where name='Germany' 2.show the name and the population for 'Sweden', 'Norway' and 'Denmark'.select name, populat...
SQLZOO练习笔记-USING NULL
yizhu007_的博客
10-06 182
List the teachers who have NULL for their department. SELECT name FROM teacher WHERE dept IS NULL Note the INNER JOIN misses the teachers with no department and the departments with no teacher. ...
Using Null -SQLZOO
Zyd_code的博客
06-06 361
Using Null -SQLZOO 前言 记录一下自己在https://sqlzoo.net复习sql时写的sql语句 此篇为Using Null 篇章 涉及sql知识点 Null JOIN 、LEFT JOIN 、RIGHT JOIN COUNT COALESCE CASE 知识点讲解 想选出Null的值不能写?=NULL要写？ is NULL JOIN(INNER JOIN) 产生的结果集是两表的交集 LEFT JOIN 产生的结果集是表1的所有以及表2中与表1匹配的值 RIGHT JOIN产生的
SQL-SERVER第三版课后答案详解
"该资源是关于SQL Server的第三版课程的课后答案，包含了多个实验的习题解答，包括创建数据库、定义数据表结构、插入数据等操作。主要涉及的数据库名为`jxsk`和`jiaoxuedb`，涵盖了学生（S）、教师（T）、课程（C）...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值