select
    YYYYMMDD,
    COUNT(YYYYMMDD) as MEMBER_CNT
from 
    (select
        MEMBER_CODE,
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY LOGIN_DATETIME) as ROW_NUM,
        substr(strftime(LOGIN_DATETIME), 1, 10) as YYYYMMDD
    from ACCESS_LOG
    where YYYYMMDD like '2023-08%'
    )
where ROW_NUM = 1
group by YYYYMMDD
order by YYYYMMDD desc