SQL - 从机器中选择当前日期并与前一周进行比较

For the below query

对于以下查询

Sum(CASE WHEN dbo.sales.date BETWEEN '2016-07-17' AND '2016-07-23' THEN dbo.sales.sellinc END) AS ActualSales
Sum(CASE WHEN d