SQL
关注
分享
扫一扫
各种装逼各种吹
成都的一名默默无名的go浪程序员
展开
-
SQLZOO 第六套 英文 （困难版）The JOIN operation
8.Instead show the name of all players who scored a goal against Germany. SELECT distinct playerFROM game JOIN goal ON matchid = id WHERE (team1='GER' or team2='GER')and teamid != 'GER'9.Show...原创 2018-09-16 10:44:39 · 248 阅读 · 0 评论 -
SQLZOO 英文第三套 SELECT from Nobel
Change the query shown so that it displays Nobel prizes for 1950. SELECT yr, subject, winnerFROM nobelWHERE yr = 1950 Show who won the 1962 prize for Literature. SELECT winnerFROM nobelWHE...原创 2018-09-13 08:22:48 · 288 阅读 · 0 评论 -
SQLZOO 中文第二套 （困难版）
11.Show the name - but substitute Australasia for Oceania - for countries beginning with N.SELECT name, CASE WHEN continent='Oceania ' THEN 'Australasia'ELSE continent ENDFROM worldWHERE name...原创 2018-09-13 08:40:03 · 694 阅读 · 0 评论 -
SQLZOO 英文第四套（困难版） SELECT within SELECT
5. Show the name and the population of each country in Europe. Show the population as a percentage of the population of Germany.SELECT name, CONCAT(ROUND(ROUND((population / (SELECT population FR...原创 2018-09-15 11:53:13 · 462 阅读 · 0 评论