SELECT
FORMAT(MIN(LOGIN_DATETIME), 'd') 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);