这是一个使用相关子查询的想法：
with bydays as (<your query here>)select bd.*, (select sum(NumMeasured) from (select top 100 * from bydays bd2 where bd2.date <= bd.date order by date desc) t ) as Measured100, (select sum(NumPassingd) from (select top 100 * from bydays bd2 where bd2.date <= bd.date order by date desc) t ) as Measured100from bydays
