SELECT
    FIRST_LOGIN_DATE AS 'FIRST_LOGIN'
    , COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    (SELECT
        MEMBER_CODE
        , MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN_DATE
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
    ) AS SUB
WHERE
    FIRST_LOGIN BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC;