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