Sql 汇总

select count(*) from
(
select studentId as stuId, avg(score) as avgScore from evalResult where classId = 266 and evalItemType like '%認知發展→%'  group by studentId
) er where er.avgScore >3 and er.avgScore<=4