SELECT DATE(M) AS FIRST_LOGIN, COUNT(*) AS MEMBER_CNT
FROM (SELECT MEMBER_CODE, MIN(LOGIN_DATETIME) AS M FROM ACCESS_LOG GROUP BY MEMBER_CODE) A
WHERE M BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
GROUP BY 1 ORDER BY 1 DESC;