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