with FIRST_TIME (CODE,LOGTIME) AS(
    SELECT MEMBER_CODE,MIN(strftime('%Y-%m-%d', date(LOGIN_DATETIME)))
    FROM ACCESS_LOG
    GROUP BY MEMBER_CODE
)

SELECT LOGTIME AS FIRST_LOGIN,COUNT(*) AS MEMBER_CNT
FROM FIRST_TIME
WHERE LOGTIME BETWEEN '2023-08-01' AND '2023-08-31'
group BY LOGTIME
ORDER BY LOGTIME DESC