SELECT
    DATE(LOGIN_DATETIME) as 'FIRST_LOGIN'
    ,COUNT(MEMBER_CODE) as 'MEMBER_CNT'
FROM
    ACCESS_LOG
WHERE
    LOGIN_DATETIME >= '2023-08-01 00:00:00'
AND
    LOGIN_DATETIME < '2023-09-01 00:00:00'
GROUP BY
    DATE(LOGIN_DATETIME)
ORDER BY
    LOGIN_DATETIME desc
;