需求背景来自京东外卖-数据研发二面已知一张京东外卖骑手收入表 dws_jd_emp_salary_1d,存放各地区各骑手当日的外卖收入情况,计算各地区骑手当日收入前三的名单BJ001300BJ002100BJ003200BJ004150BJ005120BJ006500BJ007380BJ008300SH009600SH010360SQL代码如下: select area_id, emp_id, salary from ( select area_id, emp_id, salary, row_number() over(partition by area_id order by salary ...