SELECT 
    FIRST_LOGIN, 
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    (
        SELECT 
            MEMBER_CODE,
            date(MIN(LOGIN_DATETIME)) AS FIRST_LOGIN
        FROM
            ACCESS_LOG
        GROUP BY
            MEMBER_CODE
    )
WHERE
    FIRST_LOGIN BETWEEN "2023-08-01" AND "2023-08-31"
GROUP BY
    FIRST_LOGIN
ORDER BY 
    FIRST_LOGIN DESC
;