查询学生考试得分区间人数,根据"10-20","20-30","30-40","40-50","50-60","60-70","70-80","80-90","90-100"分组

select elt(
interval(get_point,10,20,30,40,50,60,70,80,90),
"10-20","20-30","30-40","40-50","50-60","60-70","70-80","80-90","90-100"
) as score_level ,count(*) as peopleNum
from pf_work_history
WHERE work_id = #{workId}
group by elt(
interval(get_point,10,20,30,40,50,60,70,80,90),
"10-20","20-30","30-40","40-50","50-60","60-70","70-80","80-90","90-100"
);
posted @   了悟  阅读(39)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 地球OL攻略 —— 某应届生求职总结
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· 提示词工程——AI应用必不可少的技术
· .NET周刊【3月第1期 2025-03-02】
点击右上角即可分享
微信分享提示