select MIN(LOGIN_DATETIME) AS FIRST_LOGIN,
COUNT (MEMBER_CODE) as MEMBER_CNT
from ACCESS_LOG
where LOGIN_DATETIME > '2023-07-31 23:59:59'
group by DATE(LOGIN_DATETIME);