SELECT f_longin as FIRST_LOGIN, COUNT(*) as MEMBER_CNT
FROM (
 SELECT DISTINCT MEMBER_CODE, MIN(LOGIN_DATETIME) as f_longin
 FROM ACCESS_LOG
 WHERE datetime(LOGIN_DATETIME) >= datetime('2023-08-01 00:00:00') and datetime(LOGIN_DATETIME) <= datetime('2023-08-31 23:59:59')
 GROUP BY MEMBER_CODE
)
GROUP BY f_longin
ORDER BY FIRST_LOGIN DESC