select * from ( select max(ID) ID ,avg(fenshu) AvgFen from tb group by ID ) as tb1 where AvgFen>60
select id from tbl group by id having avg(score)>60
34,590
社区成员
254,589
社区内容
加载中
试试用AI创作助手写篇文章吧