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