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

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