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