用一条sql语句查询平均分大于60的id解决方案

select id from tbl group by id having avg(score)>60
------解决方案--------------------
探讨


SQL code

select id from tbl group by id having avg(score)>60

------解决方案--------------------
SQL code
select * from (select max(ID) ID ,avg(fenshu) AvgFen from tb group by ID ) as tb1 where AvgFen>60
------解决方案--------------------
select id from record group by id having avg(fenshu)>60