题解 | 牛客每个人最近的登录日期(二)

SELECT
    u.name AS u_n,
    c.name AS c_n,
    a.date
FROM
    (
        SELECT
            user_id,
            MAX(date) AS date
        FROM
            login
        GROUP BY
            user_id
    ) a
    LEFT JOIN login l ON (l.user_id = a.user_id and a.date = l.date)
    LEFT JOIN user u ON u.id = a.user_id
    LEFT JOIN client c ON l.client_id = c.id
ORDER BY u.name