经典求最高，最多

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，当选议员即各选区得票数最高的候选人

所在选区及其团队