题解
统计不同类型题目的刷题数,并按刷题数进行升序排列
https://www.nowcoder.com/practice/3b3d13d844ce4c2ca2cd2a049cb6b695
> 正常字段写
select question_type, sum(pass_count) passCnt from questions_pass_record_detail group by question_type order by passCnt asc
> 简写为第几列
select question_type, sum(pass_count) passCnt from questions_pass_record_detail group by 1 order by 2 asc