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