SELECT
    SUBSTR(LOGIN_DATETIME, 1, 10) AS FIRST_LOGIN
    , COUNT(*) AS MEMBER_CNT
FROM
    ACCESS_LOG 
WHERE
    MEMBER_CODE IN ( SELECT DISTINCT MEMBER_CODE FROM ACCESS_LOG )
    AND LOGIN_DATETIME >= '2023-08-01' AND LOGIN_DATETIME <= '2023-08-31'
GROUP BY 
    SUBSTR(LOGIN_DATETIME, 1, 10)
ORDER BY
    LOGIN_DATETIME DESC;