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