WITH tmp as
    (SELECT
    date(min(LOGIN_DATETIME)) AS FIRST_LOGIN,
    MEMBER_CODE
    FROM ACCESS_LOG
    group by MEMBER_CODE)
    SELECT 
    FIRST_LOGIN,
    count(*) as MEMBER_CNT
    from tmp
    group by FIRST_LOGIN
    order by FIRST_LOGIN desc;