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