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

select user.name u_n,client.name c_n,login.date
from(
    select user_id,max(date) date
    from login
    group by user_id
)t1 left join login on t1.date = login.date and t1.user_id = login.user_id      
    join user on user.id = t1.user_id 
    join client on client.id = login.client_id
order by user.name