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