sqlzoo
GDUT-orzzzzzz
这个作者很懒,什么都没留下…
展开
-
sqlzoo 9+.COVID 19 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/Window_LAG其他题解连接:https://blog.csdn.net/aiqiyizz/article/details/109057732题解对应的是英文版题目。窗口函数的应用,用的是新冠的数据。。。文章目录9+ COVID 199+.1 Introducing the `covid` table9+.2 Introducing the LAG function9+.3 Number原创 2020-10-15 16:41:04 · 1311 阅读 · 2 评论 -
sqlzoo 9-.Window functions 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/Window_functions其他题解连接:https://blog.csdn.net/aiqiyizz/article/details/109057732题解对应的是英文版题目。这一节内容应该是关于一些常用的函数文章目录9- Window function9-.1 Warming up9-.2 Who won?9-.39-.49-.5 Winners Only9-.6 Scottish原创 2020-10-15 14:46:26 · 461 阅读 · 0 评论 -
sqlzoo 8+.Numeric Examples 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/NSS_Tutorial其他题解连接:https://blog.csdn.net/aiqiyizz/article/details/109057732题解对应的是英文版题目。文章目录8+ Numeric Examples8+.1 Check out one row8+.2 Calculate how many agree or strongly agree8+.3 Unhappy Comput原创 2020-10-15 11:22:46 · 316 阅读 · 0 评论 -
sqlzoo 6.JOIN 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/SUM_and_COUNT其他题解连接:https://blog.csdn.net/aiqiyizz/article/details/109057732题解对应的是英文版题目。从JOIN开始应该是难度的分水岭了。文章目录6 JOIN6.16.26.36.46.56.66.76.8 More difficult questions6.96.106.116.126.136 JOIN6.1S原创 2020-10-14 22:14:10 · 162 阅读 · 0 评论 -
sqlzoo 5.SUM and COUNT 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/SUM_and_COUNT其他题解连接:https://blog.csdn.net/aiqiyizz/article/details/109057732题解对应的是英文版题目。文章目录5 SUM and COUNT5.1 Total world population5.2 List of continents5.3 GDP of Africa5.4 Count the big countrie原创 2020-10-14 20:55:42 · 115 阅读 · 0 评论 -
sqlzoo 4.SELECT within SELECT 答案.
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial其他题解连接:https://blog.csdn.net/aiqiyizz/article/details/109057732题解对应的是英文版题目。文章目录4 SELECT within SELECT4.1 Bigger than Russia4.2 Richer than UK4.3 Neighbours of Argentina原创 2020-10-14 20:23:30 · 654 阅读 · 0 评论 -
sqlzoo 3.SELECT from Nobel 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/wiki/Self_join题解对应的是英文版题目。文章目录3 SELECT from Nobel3.1 Winners from 19503.2 1962 Literature3.3 Albert Einstein3.4 Recent Peace Prizes3.5 Literature in the 1980's3.6 Only Presidents3.7 John3.8 Chemistry and原创 2020-10-14 17:26:19 · 235 阅读 · 2 评论 -
sqlzoo 0.SELECT basics 1.SELECT name 2.SELECT from World 答案
有什么问题,欢迎评论或私聊。转载请私聊博主,谢谢。原题链接:https://sqlzoo.net/题解对应的是英文版题目。前面的题目难度不高,就整合到一次,目录查询即可。本来想多几节合一起的,不过量似乎挺大,就这样子吧。文章目录0 SELECT basics0.1 Introducing the `world` table of countries0.2 Scandinavia0.3 Just the right size1 SELECT names1.1 Pattern Matching Str原创 2020-10-14 13:22:13 · 186 阅读 · 0 评论 -
sqlzoo 9.Self join 答案
有什么问题,欢迎评论或私聊。原题链接:https://sqlzoo.net/wiki/Self_join文章目录9 Self join9.1 Summary9.29.39.4 Routes and stops9.59.69.7 Using a self join9.89.99.109 Self join9.1 SummarySELECT COUNT(*)FROM stops9.2SELECT idFROM stopsWHERE name = 'Craiglockhart'9.3我收回原创 2020-10-14 01:25:51 · 232 阅读 · 0 评论 -
sqlzoo 8.Using Null 答案
有什么问题,欢迎评论或私聊。原题链接:https://sqlzoo.net/wiki/Using_Null难度不大,摸了好久的鱼。。文章目录8 Using Null8.1 NULL, INNER JOIN, LEFT JOIN, RIGHT JOIN8.28.38.48.5 Using the COALESCE function8.68.78.88.9 Using CASE8.108 Using Null8.1 NULL, INNER JOIN, LEFT JOIN, RIGHT JOINSEL原创 2020-10-13 22:18:57 · 117 阅读 · 0 评论 -
sqlzoo 7.More JOIN operations 答案
有什么问题,欢迎评论或私聊。原题链接:https://sqlzoo.net/wiki/More_JOIN_operations#1962_movies7 More JOIN operations7.1 1962 moviesSELECT id, title FROM movie WHERE yr=19627.2 When was Citizen Kane released?SELECT yrFROM movieWHERE title = 'Citizen Kane'7.3 Star T原创 2020-10-13 18:29:00 · 144 阅读 · 0 评论 -
sqlzoo题解(by orzzzzzz)
最近在学习mysql,感觉sqlzoo的题目质量还挺好的,本身网址也是免费挺良心的,故开个题解博客,希望能进行学习与交流。原创 2020-10-13 18:24:20 · 414 阅读 · 0 评论