WITH LOGIN_AUG AS(
    SELECT MEMBER_CODE
         , MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
      FROM ACCESS_LOG
     WHERE STRFTIME('%m', LOGIN_DATETIME) = '08'
     GROUP BY MEMBER_CODE
    )
SELECT FIRST_LOGIN
     , COUNT(LOGIN_AUG.MEMBER_CODE) AS MEMBER_CNT
  FROM LOGIN_AUG
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC
;