with fl as (select 
date(login_datetime) as login_date
, member_code
from access_log
-- where date(login_datetime) between '2023-08-01' and '2023-08-31'
)
, fl2 as (select 
member_code
, min(login_date) as FIRST_LOGIN
from fl
group by member_code)
-- select * from access_log where member_code = 20000
select 
FIRST_LOGIN
, count(1) as MEMBER_CNT
from fl2
where FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by FIRST_LOGIN
order by FIRST_LOGIN desc