SELECT
 AL_FIRST_LOGIN_AUGUST.FIRST_LOGIN AS FIRST_LOGIN
 , COUNT(*) AS MEMBER_CNT
FROM
(SELECT
 AL.MEMBER_CODE
 , MIN(
  DATE(AL.LOGIN_DATETIME)
 ) AS FIRST_LOGIN
FROM
 ACCESS_LOG AS AL
GROUP BY
 AL.MEMBER_CODE
HAVING
 FIRST_LOGIN BETWEEN '2023-08-01' AND '2023-08-31'
) AS AL_FIRST_LOGIN_AUGUST
GROUP BY
 FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC
;