SELECT
    DAY AS FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    (SELECT
        DISTINCT DATE(LOGIN_DATETIME) AS DAY,
        MEMBER_CODE
    FROM
        ACCESS_LOG
    WHERE
        LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31'
    )
GROUP BY
    DAY
ORDER BY
    FIRST_LOGIN DESC
;