SELECT
    SUBSTR(LOGIN_DATETIME, 1, 10) AS FIRST_LOGIN
    , COUNT(*) AS MEMBER_CNT
FROM
    ACCESS_LOG 
WHERE
    LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31'
    AND (MEMBER_CODE, ACCESS_ID) IN (SELECT MEMBER_CODE, ACCESS_ID FROM ACCESS_LOG GROUP BY MEMBER_CODE HAVING MIN(ACCESS_ID) )
GROUP BY 
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC;