![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlzoo刷题笔记
文章平均质量分 86
sqlzoo刷题笔记
小鱼粥
数据分析学习中~
展开
-
sqlzoo刷题笔记-07 | The JOIN operation
网址:https://sqlzoo.net/wiki/The_JOIN_operation1、show thematchidandplayername for all goals scored by Germany. To identify German players, check for:teamid = 'GER'显示德国队进球对应的matchid 和playerSELECT matchid, player FROM goal WHERE teamid = 'GER...原创 2021-01-22 11:38:52 · 329 阅读 · 1 评论 -
sqlzoo刷题笔记-06 | SELECT within SELECT Tutorial
网址:https://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial1、List each countrynamewhere thepopulationis larger than that of 'Russia'. 列出人口大于"俄罗斯"的每个国家/地区名称。world(name, continent, area, population, gdp)SELECT nameFROM worldWHERE populatio...原创 2021-01-08 18:57:08 · 256 阅读 · 0 评论 -
sqlzoo刷题笔记-05 | SELECT names
网址:https://sqlzoo.net/wiki/SELECT_names1、You can useWHERE name LIKE 'B%'to find the countries that start with "B".The% is awild-cardit can match any charactersFind the country that start with Y 查找以 Y 开始的国家/地区。SELECT name FROM worldWHE...原创 2021-01-07 22:45:19 · 293 阅读 · 0 评论 -
sqlzoo刷题笔记-04 | SELECT from Nobel
网址:https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial1、Change the query shown so that it displays Nobel prizes for 1950.显示 1950 年的诺贝尔奖。SELECT yr, subject, winnerFROM nobelWHERE yr = 19502、Show who won the 1962 prize for Literature.显示谁赢得了 1962 年的文学原创 2021-01-03 20:21:45 · 1062 阅读 · 3 评论 -
sqlzoo刷题笔记-03 | SELECT basics
网址:https://sqlzoo.net/wiki/SELECT_basics1、The example uses a WHERE clause to show the population of 'France'. Note that strings (pieces of text that are data) should be in 'single quotes';Modify it to show the population of GermanySELECT population原创 2020-12-31 13:04:42 · 153 阅读 · 0 评论 -
sqlzoo刷题笔记-02 | SUM and COUNT
网址:https://sqlzoo.net/wiki/SUM_and_COUNT1、Show the totalpopulationof the world.显示世界总人口数。SELECT SUM(population)FROM world2、List all the continents - just once each.列出所有大陆 - 每个大陆只列出一次。SELECT DISTINCT continentFROM world3、Give the total GD..原创 2020-12-31 12:49:27 · 175 阅读 · 0 评论 -
sqlzoo刷题笔记-01 | SELECT from WORLD
网址:https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial1、IntroductionRead the notes about this table.Observe the result of running this SQL command to show the name, continent and population of all countries.观察运行此 SQL 命令的结果。SELECT name, continent, .原创 2020-12-30 21:57:19 · 851 阅读 · 2 评论