SQLZOO
文章平均质量分 75
yizhu007_
这个作者很懒,什么都没留下…
展开
-
SQLZOO练习笔记-Select from World Tutorial
SQLZOO练习笔记-Select from World Tutorial小白头一次在CSDN上发博客…这个系列主要是想记录一下自己的DQLZOO练习,也希望大家不吝赐教~哪里写错了或者有更好的方法还请多多指教啦。原创 2018-10-05 16:30:18 · 229 阅读 · 0 评论 -
SQLZOO练习笔记-select from nobel tutorial
SELECT yr, subject, winnerFROM nobelWHERE yr = 1950SELECT winner FROM nobelWHERE yr = 1962 AND subject = ‘Literature’select yr, subject from nobelwhere winner = ‘Albert Einstein’...原创 2018-10-05 16:34:49 · 149 阅读 · 0 评论 -
SQLZOO练习笔记-Select within select tutorial
SELECT name FROM worldWHERE population > (SELECT population FROM world WHERE name=‘Russia’)select name from worldwhere continent = ‘Europe’and gdp/population > (select gdp/populatio...原创 2018-10-05 16:40:58 · 203 阅读 · 0 评论 -
SQLZOO练习笔记-SUM AND COUNT
SELECT SUM(population) FROM worldselect distinct continent from worldselect sum(gdp) from worldwhere continent = ‘Africa’select count(distinct name) from worldwhere area >= ...原创 2018-10-05 17:11:47 · 154 阅读 · 0 评论 -
SQLZOO练习笔记-the join operation
Modify it to show the matchid and player name for all goals scored by Germany. To identify German players, check for: teamid = ‘GER’SELECT matchid, player FROM goalWHERE teamid = ‘GER’2.Show id...原创 2018-10-05 22:24:25 · 353 阅读 · 0 评论 -
SQLZOO练习笔记-MORE JOIN OPERATIONS
List the films where the yr is 1962 [Show id, title]SELECT id, title FROM movieWHERE yr=1962Give year of ‘Citizen Kane’.select yr from moviewhere title = ‘Citizen Kane’3.List all of the ...原创 2018-10-06 17:29:23 · 324 阅读 · 0 评论 -
SQLZOO练习笔记-USING NULL
List the teachers who have NULL for their department.SELECT name FROM teacherWHERE dept IS NULLNote the INNER JOIN misses the teachers with no department and the departments with no teacher....原创 2018-10-06 18:34:43 · 183 阅读 · 0 评论