![](https://img-blog.csdnimg.cn/2019092715111047.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
MYSQL
sql笔记
QMai
这个作者很懒,什么都没留下…
展开
-
SQLZOO答案6:More_JOIN_operations/zh
/More_JOIN_operations/zh SELECT id,title FROM movie WHERE yr=1962 select yr FROM movie WHERE title='Citizen Kane' select id,title,yr from movie where title like 'Star Trek%' order by yr select title from movie where id in(11768, 1195..原创 2020-09-15 09:29:08 · 142 阅读 · 0 评论 -
SQLZOO答案1:SELECT_from_WORLD_Tutorial/zh答案
SQLZOO:SELECT_from_WORLD_Tutorial/zh SELECT name, continent, population FROM world SELECT name FROM world WHERE population>200000000 SELECT name,gdp/population FROM world WHERE population>200000000 SELECT name,population/1000000 FRO..原创 2020-09-12 22:19:11 · 232 阅读 · 0 评论 -
SQLZ00答案2:SELECT_from_Nobel_Tutorial/zh答案
sqlzoo.net/SELECT_from_Nobel_Tutorial/zh 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' select winner from n..原创 2020-09-13 00:08:18 · 157 阅读 · 0 评论 -
SQLZ00答案3:SELECT_within_SELECT_Tutorial/zh
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/population from world where name='United Kingdom') select nam...原创 2020-09-14 07:59:29 · 311 阅读 · 0 评论 -
SQLZ00答案4:SUM_and_COUNT/zh
SUM_and_COUNT/zh SELECT sum(population) FROM world select distinct continent from world SELECT sum(gdp) FROM world where continent='Africa' select count(name) from world where area>=1000000 SELECT sum(population) FROM world where n..原创 2020-09-14 08:20:19 · 133 阅读 · 0 评论 -
SQLZOO答案5:The_JOIN_operation/zh
The_JOIN_operation/zh SELECT matchid,player FROM goal WHERE teamid = 'GER' SELECT id,stadium,team1,team2 FROM game where id=1012 select a.player,a.teamid,b.stadium,b.mdate from goal as a left join game as b on a.matchid = b.id where..原创 2020-09-14 14:30:16 · 129 阅读 · 0 评论