题解

统计不同类型题目的刷题数,并按刷题数进行升序排列

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

全部评论

相关推荐

投递华为等公司10个岗位
点赞 评论 收藏
转发
3 收藏 评论
分享
牛客网
牛客企业服务