嘿,伙计们,我在解决SQL练习时遇到了问题:
SELECT
EXTRACT(YEAR FROM o.订单日期) AS year,
EXTRACT(MONTH FROM o.订单日期) AS month,
COUNT(DISTINCT o.客户ID) AS total_customers
FROM `store1.Orders` AS o
JOIN `store1.Customers` AS c
ON o.客户ID = c.客户ID
GROUP BY year, month
ORDER BY month ASC
store1的列.订单:
- 订单号
- 订单日期
- 购买状态
- 收入
- 客户ID
store1的列.客户:
- 客户ID
- 名称
- 邮箱
有人能帮我吗?