经典求最高，最多
SELECT
constituency,
party,
votes
FROM(SELECT
constituency,
party,
votes,
rank() over(PARTITION by constituency ORDER BY votes desc) 得票排序
FROM ge
WHERE constituency in ('S14000021','S14000022','S14000023','S14000024','S14000025','S14000026')
and yr =2017
GROUP BY constituency,party,votes) a
WHERE 得票排序=1
查询2017年所有在爱丁堡的选区当选议员所在选区（constituency）及其团队（party），
已知爱丁堡选区编号为S14000021至S14000026，当选议员即各选区得票数最高的候选人
所在选区及其团队
