select
    LOGIN_DATE as  FIRST_LOGIN
    , count(MEMBER_CODE) as MEMBER_CNT
from
    (select
        substr(min(LOGIN_DATETIME),1,10) as LOGIN_DATE
        , MEMBER_CODE
    from 
        ACCESS_LOG
    group by 
        MEMBER_CODE
    having 
        min(LOGIN_DATETIME) like '2023-08%')
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc
;