select 
    fv FIRST_LOGIN
    , count( access_id) MEMBER_CNT
from 
(
select
    first_value(date(login_datetime)) over(partition by l.access_id) fv,
    l.access_id
from 
    access_log l    
WHERE
    l.login_datetime between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
    
) tmp
group by fv 
order by fv desc