MySQL Couting 重复项的重复项

Question

我有一个充满订单的数据库，其中包含一个 id 和一个 customerName。我想做的是，找出有多少不同的订单大小。如果客户下了多个订单，将包含多个包含相同 customerName

的行

我想要一个看起来有点像这样的输出:

+------------+----------+
| size       | quantity |
+------------+----------+
| 1          |      321 |
| 2          |      148 |
| 3          |       98 |
| 4          |       63 |
| 5          |       22 |
| 6          |        3 |
+------------+----------+

编辑 1:

+------------------+-----------------+------+-----+---------+----------------+
| Field            | Type            | Null | Key | Default | Extra          |
+------------------+-----------------+------+-----+---------+----------------+
| id               | int(6) unsigned | NO   | PRI | NULL    | auto_increment |
| signupDate       | date            | YES  |     | NULL    |                |
| customerName     | varchar(128)    | YES  |     | NULL    |                |
+------------------+-----------------+------+-----+---------+----------------+

Answer 1

select 
size,count(1)
from
(
select customerName,count(1) as size from table group by customerName
) tmp group by  size

如果这是你想要的？