SELECT
    strftime('%Y-%m-%d', 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
    FIRST_LOGIN
ORDER BY
    LOGIN_DATETIME desc
;