所有订单的件数分布mysql

MySQL中所有订单的件数分布可以通过以下代码实现:

SELECT COUNT(*) AS `count`, `quantity` FROM `orders` GROUP BY `quantity` ORDER BY `count` DESC;