44.Merchant - 客户的地区分布报告

dimestore想推出一个区域营销活动，管理想要一个按照每个区域的客户数量按邮政编码分组的报告．

SELECT COUNT(customer) AS customerCount, state
FROM customer 
GROUP BY state
ORDER BY customerCount DESC

结果：

Previous43.Merchant - 找到最有价值的顾客Next45.Merchant - 每月报告活动的客户

Last updated

Was this helpful?