本文通过SQLZOO中的示例介绍了窗口函数在处理选举数据时的应用，包括如何显示不同选举年的政党排名、分区排名、爱丁堡地区赢家、苏格兰地区各党派席位等。强调了RANK、PARTITION BY、COUNT和GROUP BY等函数的使用技巧，同时指出在线练习平台可能影响深度思考的问题。
1.Show the lastName, party and votes for the constituency ‘S14000024’ in 2017.
SELECT lastName, party, votes
FROM ge
WHERE constituency = 'S14000024' AND yr = 2017
ORDER BY votes DESC
- 在题目给出的范例基础上无脑改就完事了
2.You can use the RANK function to see the order of the candidates. If you RANK using (ORDER BY votes DESC) then the candidate with the most votes has rank 1.
Show the party and RANK for constituency S14000024 in 2017. List the output by party
SELECT party, votes,
RANK() OVER (ORDER BY votes DESC) as posn
FROM ge
WHERE constituency = 'S14000024' AND yr = 
最低0.47元/天 解锁文章
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
