9-Window function
练习题链接: https://sqlzoo.net/wiki/Window_functions
1.Warming up
SELECT lastName
,party
,votes
FROM ge
WHERE constituency = 'S14000024'
AND yr = 2017
ORDER BY votes DESC
2.Who won?
SELECT party
,votes
,RANK() OVER (ORDER BY votes DESC) as posn
FROM ge
WHERE constituency = 'S14000024'