select
WK.LOGIN_DATE as FIRST_LOGIN,
count(WK.LOGIN_DATE) as MEMBER_CNT
from
(
select
distinct
MEMBER_CODE,
date(LOGIN_DATETIME) as LOGIN_DATE
from ACCESS_LOG
where
LOGIN_DATETIME between '2023-08-01 00:00.000' and '2023-08-31 23:59:59.999'
) WK
group by WK.LOGIN_DATE
order by FIRST_LOGIN desc;