SELECT
SUBSTRING(LOGIN_DATETIME, 0,11) AS FIRST_LOGIN,
COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM(
SELECT
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 MEMBER_CODE
)
GROUP BY FIRST_LOGIN
ORDER BY LOGIN_DATETIME DESC