Closed pingpongworks closed 4 years ago
SELECT `addr`, `month`, COUNT(`addr`) AS cnt FROM
(
SELECT SUBSTRING_INDEX(ui.address2, ' ', 1) AS `addr`, DATE_FORMAT(o.rental_date, '%m') AS month
FROM `order` o
JOIN user_info ui ON o.user_id = ui.user_id
WHERE rental_date BETWEEN '2020-01-01' AND '2020-05-31'
AND online = 1
AND status_id = 9
AND ui.address2 IS NOT NULL
) x
GROUP BY `addr`, `month`
ORDER BY `addr`, `month`;
SELECT `addr`, COUNT(`addr`) AS cnt FROM
(
SELECT SUBSTRING_INDEX(ui.address2, ' ', 1) AS `addr`
FROM `order` o
JOIN user_info ui ON o.user_id = ui.user_id
WHERE rental_date BETWEEN '2020-01-01' AND '2020-05-31'
AND online = 1
AND status_id = 9
AND ui.address2 IS NOT NULL
) x
GROUP BY `addr`
ORDER BY `addr`;
결과는 이메일로 보내드렸습니다.
확인했어요. 감사합니다.