题解 | 牛客每个人最近的登录日期(二)
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
with t1 as
(select
u.name as u_n,
c.name as c_n,
l.date,
l.user_id
from
login l
left join client c on l.client_id=c.id
left join user u on l.user_id=u.id)
select
t2.u_n,t1.c_n,t2.date
from
(select
u_n,
max(date) as date
from
t1
group by
u_n)t2
left join
t1
on
t2.u_n=t1.u_n and t2.date=t1.date
order by
t1.u_n asc
辅导员肯定不能同意，不然你出事了，他要承担责任。但是，脚和脑子都长在你自己身上，使用它还需要向辅导员报告么？
辅导员必须按流程拒绝你，然后你拿出成年人的态度，做自己的选择。