![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
新兰柯哀
技术宅,单身狗。
展开
-
SQLZOO练习记录-NULL
目录 Using NULL Teachers and Departments Using NULL Teachers and Departments 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 depa原创 2020-09-19 17:34:31 · 141 阅读 · 0 评论 -
SQLZOO练习记录-JOIN
The JOIN operation JOIN and UEFA EURO 2012 1.Modify it to show thematchidandplayername for all goals scored by Germany. SELECT matchid, player FROM goal WHERE teamid='GER' 2.Show id, stadium, team1, team2 for just game 1012 SELECT id, stadium,...原创 2020-09-16 23:17:40 · 279 阅读 · 0 评论 -
SQLZOO练习记录-SUM and COUNT
The nobel table can be used to practice more SUM and COUNT functions. 1.Show the total number of prizes awarded. SELECT COUNT(winner) FROM nobel 2.List each subject - just once SELECT DISTINCT subject FROM nobel 3.Show the total number of prizes a原创 2020-09-16 20:30:04 · 248 阅读 · 1 评论