将星期一的数据与SQL Server中的前一个星期一进行比较

I am trying to figure out how to compare the current day's data to the same data from a week ago, 2 weeks, etc. Let's say I have a table called "Order" with 2 columns:I am trying to figure out how to compare the cu