SQL学习
Charlies_Yu
这个作者很懒,什么都没留下…
展开
-
SQLZOO练习题(1)
SQLZOO练习题(1)sqlzoo上较难的一些sql查询练习题及其解题思路。题目:Put the continents right…Oceania becomes AustralasiaCountries in Eurasia and Turkey go to Europe/AsiaCaribbean islands starting with ‘B’ go to North A...原创 2019-03-25 17:47:49 · 587 阅读 · 0 评论 -
SQLZOO练习题(2)
SQLZOO练习题(2)sqlzoo上较难的一些sql查询练习题及其解题思路。题目:The expression subject IN (‘Chemistry’,‘Physics’) can be used as a value - it will be 0 or 1.Show the 1984 winners and subject ordered by subject and win...原创 2019-03-25 18:57:37 · 349 阅读 · 0 评论 -
SQLZOO练习题(3)
SQLZOO练习题(3)sqlzoo上较难的一些sql查询练习题及其解题思路。待查询表格样式:题目:找出洲份,當中全部國家都有少於或等於 25000000 人口. 在這些洲份中,列出國家名字name,continent 洲份和population人口。答案:select name, continent, population from world a where 25000000 ...原创 2019-03-25 22:16:00 · 323 阅读 · 0 评论 -
SQLZOO练习题(4)
SQLZOO练习题(4)sqlzoo上较难的一些sql查询练习题及其解题思路。表格结构:题目:List every match with the goals scored by each team as shown. This will use “CASE WHEN” which has not been explained in any previous exercises.Not...原创 2019-03-26 11:30:48 · 394 阅读 · 0 评论 -
SQLZOO练习题(6)
SQLZOO练习题(6)sqlzoo上较难的一些sql查询练习题及其解题思路。表格结构:题目:Find the routes involving two buses that can go from Craiglockhart to Sighthill.Show the bus no. and company for the first bus, the name of the sto...原创 2019-03-26 18:09:48 · 380 阅读 · 0 评论 -
SQLZOO练习题(5)
SQLZOO练习题(5)sqlzoo上较难的一些sql查询练习题及其解题思路。表格结构:题目:列出1978年首影的電影名稱及角色數目,按此數目由多至少排列。答案:select title, count(*) cfrom movie join castingon movie.id=movieidand yr=1978group by titleorder by c desc;...原创 2019-03-26 18:50:18 · 512 阅读 · 0 评论