题解
统计不同类型题目的刷题数,并按刷题数进行升序排列
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
SHEIN希音公司福利 280人发布