题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select u.name u_n, a.date, sum(b.number) ps_num
from passing_number a, passing_number b, user u
where a.date >= b.date and a.user_id = b.user_id and a.user_id = u.id
group by a.user_id, u_n, a.date
order by a.date, u_n
SQL练习 文章被收录于专栏
已完成牛客的SQL练习。接下来是算法的练习
投递OPPO等公司10个岗位 >
