题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT
LEFT(t.t_time, 7) AS time,
SUM(t_amount) AS total
FROM trade t
JOIN customer c
ON t.t_cus = c.c_id
WHERE c.c_name = 'Tom'
AND t.t_type = 1
GROUP BY LEFT(t.t_time, 7)
HAVING time LIKE '2023%'
ORDER BY LEFT(t.t_time, 7)
投递华为HUAWEI等公司8个岗位