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