![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql zoo
山区的花花
这个作者很懒,什么都没留下…
展开
-
sqlzoo - 9 Self join
@TOG3.Give the id and the name for the stops on the ‘4’ ‘LRT’ service.列出LRT公司4号线公交停靠的站名及站的ID号根据答案推的order by posselect id, name from stops join route on stops.id = route.stop where company = 'LRT' and num = 4 order by pos4. Routes and stopsThe原创 2020-11-26 19:53:49 · 321 阅读 · 0 评论 -
sqlzoo - 9- Window functions
目录2. * Rank (Who won?)3. * PARTITION BY4. - Edinburgh Constituency5. * Winners Only6. Scottish seats- 代表省略 与前面题型相同* 代表错题,重点看? 代表有疑问2. * Rank (Who won?)You can use the RANK function to see the order of the candidates. If you RANK using (ORDER BY vot原创 2020-11-22 22:17:26 · 575 阅读 · 0 评论 -
sqlzoo - 8 Using Null & 8+ Numeric Examples / NSS Tutorial
目录5. COALESCE8. The number of staff in each department9. CASE- 代表省略 与前面题型相同* 代表错题,重点看? 代表有疑问5. COALESCEUse COALESCE to print the mobile number. Use the number ‘07986 444 2266’ if there is no number given. Show teacher name and mobile number or ‘0798原创 2020-11-21 23:58:53 · 198 阅读 · 0 评论 -
sqlzoo - 7 More JOIN operations
目录6. Cast list for Casablanca7. - Alien cast list8. - Harrison Ford movies9. Harrison Ford as a supporting actor10. Lead actors in 1962 movies11. Busy years for Rock Hudson- 代表省略 与前面题型相同* 代表错题,重点看6. Cast list for CasablancaObtain the cast list for ‘C原创 2020-11-21 19:35:37 · 320 阅读 · 0 评论