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