SELECT
    FIRST_LOGIN
    , COUNT(CODE) AS MEMBER_CNT
FROM (
SELECT
    MEMBER_CODE AS CODE
    , DATE(MIN(LOGIN_DATETIME)) AS FIRST_LOGIN
FROM ACCESS_LOG
WHERE LOGIN_DATETIME LIKE '2023-08-%'
GROUP BY MEMBER_CODE
)
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC;