WITH FIRST_LOGIN AS (
    SELECT
         MEMBER_CODE
        ,MIN(DATE (LOGIN_DATETIME)) AS FIRST_LOGIN_DATE 
    FROM ACCESS_LOG 
    GROUP BY MEMBER_CODE
)
SELECT
     FIRST_LOGIN_DATE AS FIRST_LOGIN
    ,COUNT(FIRST_LOGIN_DATE) AS MEMBER_CNT
FROM FIRST_LOGIN
WHERE substr(FIRST_LOGIN_DATE, 1, 7) = '2023-08' 
GROUP BY FIRST_LOGIN