查询学生考试得分区间人数,根据"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"
);
下班记得打卡
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 地球OL攻略 —— 某应届生求职总结
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· 提示词工程——AI应用必不可少的技术
· .NET周刊【3月第1期 2025-03-02】