SELECT
  LOGIN_DATE AS FIRST_LOGIN,
  COUNT(MEMBER_CODE) AS MEMBER_CNT

FROM
(
	SELECT
	  DATE(MIN(LOGIN_DATETIME)) AS LOGIN_DATE,
	  MEMBER_CODE AS MEMBER_CODE

	FROM
		ACCESS_LOG
	GROUP BY
		DATE(MEMBER_CODE)
	) AS SUB

WHERE
	LOGIN_DATE BETWEEN '2023-08-01' AND '2023-08-31'

GROUP BY
	DATE(LOGIN_DATE)

ORDER BY
	FIRST_LOGIN DESC;