MYSQL
sql笔记
QMai
这个作者很懒,什么都没留下…
展开
-
SQLZOO答案6:More_JOIN_operations/zh
/More_JOIN_operations/zhSELECT id,title FROM movie WHERE yr=1962select yr FROM movie WHERE title='Citizen Kane'select id,title,yr from movie where title like 'Star Trek%' order by yrselect title from movie where id in(11768, 1195..原创 2020-09-15 09:29:08 · 145 阅读 · 0 评论 -
SQLZOO答案1:SELECT_from_WORLD_Tutorial/zh答案
SQLZOO:SELECT_from_WORLD_Tutorial/zhSELECT name, continent, population FROM worldSELECT name FROM worldWHERE population>200000000SELECT name,gdp/population FROM worldWHERE population>200000000SELECT name,population/1000000 FRO..原创 2020-09-12 22:19:11 · 235 阅读 · 0 评论 -
SQLZ00答案2:SELECT_from_Nobel_Tutorial/zh答案
sqlzoo.net/SELECT_from_Nobel_Tutorial/zhselect yr,subject,winner from nobel where yr=1950select 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 · 160 阅读 · 0 评论 -
SQLZ00答案3:SELECT_within_SELECT_Tutorial/zh
SELECT name FROM world WHERE population >(select population from world where name='Russia')select name from worldwhere continent='Europe' and gdp/population>(select gdp/population from world where name='United Kingdom') select nam...原创 2020-09-14 07:59:29 · 313 阅读 · 0 评论 -
SQLZ00答案4:SUM_and_COUNT/zh
SUM_and_COUNT/zhSELECT sum(population)FROM worldselect distinct continent from worldSELECT sum(gdp)FROM worldwhere continent='Africa'select count(name) from world where area>=1000000SELECT sum(population)FROM world where n..原创 2020-09-14 08:20:19 · 135 阅读 · 0 评论 -
SQLZOO答案5:The_JOIN_operation/zh
The_JOIN_operation/zhSELECT matchid,player FROM goal WHERE teamid = 'GER'SELECT id,stadium,team1,team2 FROM game where id=1012select a.player,a.teamid,b.stadium,b.mdatefrom goal as aleft join game as bon a.matchid = b.idwhere..原创 2020-09-14 14:30:16 · 131 阅读 · 0 评论