SELECT
 SUBSTR(FIRST_LOGIN, 1, 10) AS FIRST_LOGIN
 ,COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM(
    SELECT
     MEMBER_CODE
     ,MIN(LOGIN_DATETIME) AS FIRST_LOGIN
    FROM ACCESS_LOG
    GROUP BY 1
)
WHERE SUBSTR(FIRST_LOGIN, 1, 7) = '2023-08' 
GROUP BY 1
ORDER BY 1 DESC