with FIRST_TIME (CODE,LOGTIME) AS(
    SELECT MEMBER_CODE,MIN(LOGIN_DATETIME)
    FROM ACCESS_LOG
    WHERE strftime('%Y-%m-%d', date(LOGIN_DATETIME)) BETWEEN '2023-08-01' AND '2023-08-31'
    GROUP BY MEMBER_CODE
)


SELECT strftime('%Y-%m-%d', date(LOGTIME)) AS FIRST_LOGIN,COUNT(*) AS MEMBER_CNT
FROM FIRST_TIME
group BY strftime('%Y-%m-%d', date(LOGTIME))
ORDER BY LOGTIME DESC