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