mysql数据库sql语句对统计函数中的值进行排序的方法

我们只需要对统计函数的别名直接进行排序即可

SELECT
	ai_id,
	SUM( share_number ) AS 'share_total' 
FROM
	`qipa250_activity_share` 
WHERE
	share_number > 0 
GROUP BY
	shop_id DESC 
ORDER BY
	share_total DESC