with sub as (
    select date(min(login_datetime)) as day
    from access_log
    group by member_code
)

select day as FIRST_LOGIN, count(*) as MEMBER_CNT
from sub
where day between '2023-08-01' and '2023-08-31'
group by day
order by FIRST_LOGIN desc;