SELECT salesman, AVG(commission) AS avg_commission FROM sales GROUP BY salesman ORDER BY avg_commission DESC;
上一篇:按平均评分排序,同时按总评价数量排序。
下一篇:按平均值分组,忽略零值。