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