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