SELECT DATE(MIN(LOGIN_DATETIME)) AS FIRST_LOGIN, COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM ACCESS_LOG
WHERE LOGIN_DATETIME >= '2023-08-01 00:00:00' AND LOGIN_DATETIME < '2023-09-01 00:00:00'
GROUP BY DATE(LOGIN_DATETIME)
ORDER BY FIRST_LOGIN DESC;