题解 | SQLW4 获取指定客户每月的消费额
WITH t1 AS (
SELECT SUBSTR(t_time,1,7) AS time,
SUM(t_amount) AS total
FROM trade a
LEFT JOIN customer b
ON a.t_cus = b.c_id
WHERE c_name = 'Tom'
AND YEAR(t_time) = '2023'
AND t_type = 1
GROUP BY time
ORDER BY time
)
SELECT * FROM t1;
# 这道题的注意点是 t_type 需要选择为消费类型！
曼迪匹艾公司福利 94人发布
