SELECT
FIRST_LOGIN,
COUNT(*)
FROM
(SELECT
    MEMBER_CODE,
    MIN(date(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;