SELECT wk2 FIRST_LOGIN
      ,COUNT(*) MEMBER_CNT
FROM(
SELECT MEMBER_CODE wk1
      ,SUBSTR(LOGIN_DATETIME,1,10) wk2
FROM ACCESS_LOG
GROUP BY MEMBER_CODE
)
WHERE wk2  > '2023-07-31'
  AND wk2  < '2023-09-01'
GROUP BY wk2
ORDER BY 1 DESC
;