WITH T AS(
    SELECT
        MEMBER_CODE,
        MIN(DATE(LOGIN_DATETIME)) AS MINDATE
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
)
SELECT
    MINDATE AS FIRST_LOGIN,
    COUNT(*) AS MEMBER_CNT
FROM
    T
WHERE
    MINDATE BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY
    MINDATE
ORDER BY
    FIRST_LOGIN DESC