with a as(
select MEMBER_CODE as m,
min(date(LOGIN_DATETIME)) as l
from  ACCESS_LOG
group by MEMBER_CODE
)
select l as FIRST_LOGIN,
count(*) as MEMBER_CNT
from a
group by l
having l between  '2023-08-01' and  '2023-08-31'
order by
FIRST_LOGIN DESC