select
    FIRST_LOGIN,
    COUNT(FIRST_LOGIN) 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 FIRST_LOGIN
    from ACCESS_LOG
    )
where ROW_NUM = 1
    and FIRST_LOGIN like '2023-08%'
group by FIRST_LOGIN
order by FIRST_LOGIN desc