mysql汇总各分数段人数,总平均分,总人数
SELECT
target_id,
count(0) comment_total_num,
format((avg(content_score) + avg(effect_score) + avg(method_score)) / 3.0,1) course_total_score,
COUNT(CASE WHEN c.content_score=5 THEN c.id END) five_star,
COUNT(CASE WHE