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