SELECT
    FIRST_LOGIN_DATE AS FIRST_LOGIN
    ,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    (SELECT min(date(LOGIN_DATETIME)) AS FIRST_LOGIN_DATE ,MEMBER_CODE
        FROM ACCESS_LOG
        GROUP BY MEMBER_CODE)
WHERE
    FIRST_LOGIN_DATE LIKE '2023-08%'
GROUP BY
    FIRST_LOGIN_DATE
ORDER BY
    FIRST_LOGIN DESC