/*
SELECT
 DISTINCT(date(LOGIN_DATETIME)) AS FIRST_LOGIN
 ,COUNT(DISTINCT(MEMBER_CODE)) AS MEMBER_CNT
  --,MEMBER_CODE AS MEMBER_CNT
FROM ACCESS_LOG 

WHERE LOGIN_DATETIME LIKE '2023-08%'
AND (MEMBER_CODE <> '20000' AND MEMBER_CODE <> '11000'AND MEMBER_CODE <> '15000')

GROUP BY FIRST_LOGIN

ORDER BY FIRST_LOGIN DESC
*/


SELECT
DISTINCT(date(LOGIN_DATETIME)) AS FIRST_LOGIN
,COUNT(MEMBER_CODE) AS MEMBER_CNT
--,MEMBER_CODE
FROM ACCESS_LOG 
WHERE LOGIN_DATETIME LIKE '2023-08%'
GROUP BY LOGIN_DATETIME
ORDER BY FIRST_LOGIN DESC