select
    substr(LOGIN_DATETIME,1,10) as 'FIRST_LOGIN',
    count(MEMBER_CODE) as MEMBER_CNT
from
    ACCESS_LOG
where
    LOGIN_DATETIME >= '2023-08-01 00:00:00' and LOGIN_DATETIME <= '2023-08-31 23:59:59'
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc