- 博客(7)
- 收藏
- 关注
原创 SQLZOO练习笔记-USING NULL
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. ...
2018-10-06 18:34:43 183
原创 SQLZOO练习笔记-MORE JOIN OPERATIONS
List the films where the yr is 1962 [Show id, title] SELECT id, title FROM movie WHERE yr=1962 Give year of ‘Citizen Kane’. select yr from movie where title = ‘Citizen Kane’ 3.List all of the ...
2018-10-06 17:29:23 324
原创 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 goal WHERE teamid = ‘GER’ 2.Show id...
2018-10-05 22:24:25 353
原创 SQLZOO练习笔记-SUM AND COUNT
SELECT SUM(population) FROM world select distinct continent from world select sum(gdp) from world where continent = ‘Africa’ select count(distinct name) from world where area >= ...
2018-10-05 17:11:47 154
原创 SQLZOO练习笔记-Select within select tutorial
SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name=‘Russia’) select name from world where continent = ‘Europe’ and gdp/population > (select gdp/populatio...
2018-10-05 16:40:58 203
原创 SQLZOO练习笔记-select from nobel tutorial
SELECT yr, subject, winner FROM nobel WHERE yr = 1950 SELECT winner FROM nobel WHERE yr = 1962 AND subject = ‘Literature’ select yr, subject from nobel where winner = ‘Albert Einstein’ ...
2018-10-05 16:34:49 149
原创 SQLZOO练习笔记-Select from World Tutorial
SQLZOO练习笔记-Select from World Tutorial 小白头一次在CSDN上发博客…这个系列主要是想记录一下自己的DQLZOO练习,也希望大家不吝赐教~哪里写错了或者有更好的方法还请多多指教啦。
2018-10-05 16:30:18 229
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人