SELECT FIRST_LOGIN
      ,COUNT(*) AS MEMBER_CNT
  FROM(
SELECT MEMBER_CODE
      ,SUBSTR(MIN(LOGIN_DATETIME), 0, 11) AS FIRST_LOGIN
  FROM ACCESS_LOG
 GROUP BY MEMBER_CODE
      )
 WHERE FIRST_LOGIN LIKE '2023-08%'
 GROUP BY FIRST_LOGIN
 ORDER BY FIRST_LOGIN DESC