select b.name,a.date, sum(case when a.date>=(select date from passing_number c where a.user_id=c.user_id) then a.number else 0 end) as number from passing_number a,user b where a.user_id=b.id group by a.user_id,a.date;救救我愚蠢的代码
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务