mysql - 如何在 SQL 中创建两个连续的 Group By

Question

我有这种代码

SELECT MONTH(date_entered) AS Month,sex, COUNT(*) AS Customer
  FROM customer
GROUP BY month
ORDER BY Month

我想sex (M and F)每个月分开。但是我得到的结果结合了两种性别

标签： mysqlsqlselectgroup-bycount

Answer 1

你也需要包括sex在内group by

SELECT 
    MONTH(date_entered) AS Month,
    sex, 
    COUNT(*) AS Customer
FROM customer
GROUP BY
    MONTH(date_entered),
    sex
ORDER BY 
    Month