查询学生考试得分区间人数,根据"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"
);
下班记得打卡