with FH AS(
    SELECT  
    MIN(DATE(LOGIN_DATETIME)) AS FL
    ,MEMBER_CODE
FROM ACCESS_LOG
GROUP BY MEMBER_CODE
)
SELECT
        FL AS FIRST_LOGIN
    ,   COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM FH
WHERE
    FL BETWEEN '2023-08-01' AND '2023-08-31' 
GROUP BY DATE(FL)
ORDER BY
      FIRST_LOGIN DESC
;