WITH MODIFIED_LOG AS (
    SELECT
        MEMBER_CODE
        ,SUBSTRING(MIN(LOGIN_DATETIME), 1, 10) AS FIRST_LOGIN
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
)
SELECT
    FIRST_LOGIN
    ,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    MODIFIED_LOG
WHERE
    FIRST_LOGIN BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC;