题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
SELECT u.name u_n,DATE,
(SELECT SUM(number)
FROM passing_number p1 WHERE p1.date <= p2.date
AND p1.user_id = p2.user_id) ps_num
FROM passing_number p2
LEFT JOIN user u ON u.id=p2.user_id
ORDER BY DATE, u_n ASC