update ACCESS_LOG set LOGIN_DATETIME=date(LOGIN_DATETIME);

DELETE FROM ACCESS_LOG 
WHERE LOGIN_DATETIME NOT between '2023-08-01' and '2023-08-31';

DELETE FROM ACCESS_LOG 
WHERE ACCESS_ID NOT IN (SELECT min_id from (SELECT MIN(ACCESS_ID) min_id FROM ACCESS_LOG GROUP BY MEMBER_CODE) tmp);

select distinct LOGIN_DATETIME as FIRST_LOGIN, count(LOGIN_DATETIME)
from ACCESS_LOG
group by FIRST_LOGIN
order by FIRST_LOGIN desc;