20.⭐

查询学生的总成绩并进行排名
**

 create table sum_s_temp
     select 
        a.s_id,
        sum(a.s_score) sum_s
    from
        score a
    group by 
         a.s_id;
SELECT
    a.*,
  (SELECT COUNT(sum_s) FROM sum_s_temp b WHERE b.sum_s > a.sum_s) + 1 rk
FROM
    sum_s_temp a
ORDER BY a.sum_s desc