SELECT
    MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    ACCESS_LOG
GROUP BY
    --DATE(LOGIN_DATETIME)
    MEMBER_CODE
ORDER BY
    FIRST_LOGIN DESC;