SELECT
MINMIN AS FIRST_LOGIN
,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
(SELECT 
MEMBER_CODE, SUBSTR(MIN(LOGIN_DATETIME), 1, 10) AS MINMIN
FROM ACCESS_LOG
GROUP BY MEMBER_CODE
ORDER BY LOGIN_DATETIME)
WHERE FIRST_LOGIN LIKE '2023-08%'
GROUP BY MINMIN
ORDER BY FIRST_LOGIN DESC;