因为参与人员有可能评价或者不评价,所有
select
a.classid,count(b.appraise),count(distinct a.userid),ceil(sum(b.appraise)/count(distinct b.userid))from o_classpartyinfo a,o_classpartyinfo b
where a.logid=b.logid and a.classid=b.classid
and b.appraise is not null
group by a.classid
group by a.classid
附上目标汇总表的列: