WITH MIN_DATE AS (
    SELECT MEMBER_CODE
          ,MIN(DATE(LOGIN_DATETIME)) AS LOGIN_DATETIME
    FROM ACCESS_LOG
    WHERE DATE(LOGIN_DATETIME) BETWEEN DATE('2023-08-01')
                                   AND DATE('2023-08-31')
    GROUP BY MEMBER_CODE
)
SELECT
     strftime('%Y-%m-%d', LOGIN_DATETIME) AS FIRST_LOGIN
    ,COUNT(*) AS MEMBER_CNT
FROM MIN_DATE
GROUP BY LOGIN_DATETIME
ORDER BY FIRST_LOGIN DESC
;