- 博客(2)
- 问答 (1)
- 收藏
- 关注
原创 SQLZOO答案:9 Self join
其实CSDN关于这篇文章的博客已经有很多了,但是我没有找到一篇关于第三题的答案事正确的,所以就再写了这篇How many stops are in the database.SELECT COUNT(*) FROM stopsFind the id value for the stop ‘Craiglockhart’SELECT id FROM stops WHERE name...
2020-02-24 16:58:51
359
1
原创 SQLZOO答案: 9- Window function
Show the lastName, party and votes for the constituency ‘S14000024’ in 2017.SELECT lastName, party, votes FROM ge WHERE constituency = 'S14000024' AND yr = 2017ORDER BY votes DESCShow the pa...
2020-02-24 10:56:16
4540
2
空空如也
python列表中的字典排序, 先按第一个键排序,再按第二个键排序
2020-06-13
TA创建的收藏夹 TA关注的收藏夹
TA关注的人