SELECT
    FIRST_LOGIN_DATE AS FIRST_LOGIN
,   COUNT(*) 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_DATE BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY
    FIRST_LOGIN_DATE
ORDER BY
    FIRST_LOGIN DESC;