SELECT DATE(A.LOGIN_DATETIME) AS FIRST_LOGIN
       , COUNT(A.MEMBER_CODE) AS MEMBER_CNT
FROM (SELECT MEMBER_CODE, LOGIN_DATETIME FROM ACCESS_LOG GROUP BY MEMBER_CODE ORDER BY LOGIN_DATETIME) AS A
WHERE LOGIN_DATETIME BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC;