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