with FH AS(
    SELECT  
    MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
    ,MEMBER_CODE
FROM ACCESS_LOG
GROUP BY MEMBER_CODE
)

SELECT
    DATE(FIRST_LOGIN),
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM FH
GROUP BY DATE(FIRST_LOGIN);