select date(LOGIN_DATETIME) as FIRST_LOGIN, COUNT(distinct(MEMBER_CODE)) as MEMBER_CNT
from ACCESS_LOG
where FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by FIRST_LOGIN
order by FIRST_LOGIN desc