SELECT
        SUBSTR(TMP1.MIN_LOGIN_DATETIME, 1, 10) AS FIRST_LOGIN
       ,COUNT(DISTINCT TMP1.MEMBER_CODE) AS MEMBER_CNT
    FROM
        (
            SELECT
                MIN(LOGIN_DATETIME) AS MIN_LOGIN_DATETIME
                ,MEMBER_CODE
            FROM
                ACCESS_LOG
            WHERE
                LOGIN_DATETIME BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
            GROUP BY
                MEMBER_CODE
        ) TMP1
    GROUP BY
        SUBSTR(TMP1.MIN_LOGIN_DATETIME, 1, 10)
    ORDER BY
        FIRST_LOGIN DESC
;