SELECT DATE(LOGIN_DATETIME) as FIRST_LOGIN, COUNT(DISTINCT MEMBER_CODE) as MEMBER_CNT
FROM ACCESS_LOG
WHERE LOGIN_DATETIME BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
GROUP BY DATE(LOGIN_DATETIME)
ORDER BY FIRST_LOGIN DESC;