WITH T AS (
SELECT ACCESS_ID, DATE(MIN(LOGIN_DATETIME)) AS ACCESS_DATE
FROM ACCESS_LOG
GROUP BY MEMBER_CODE
)
SELECT ACCESS_DATE AS FIRST_LOGIN, COUNT(*) AS MEMBER_CNT
FROM T
WHERE ACCESS_DATE BETWEEN "2023-08-01" AND "2023-08-31"
GROUP BY ACCESS_DATE
ORDER BY ACCESS_DATE DESC