q40_modified.sql.diff

*** q40.sql	2016-03-25 14:10:21.906553746 +0100
--- q40_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 9,18 ****
                                                                    "${database}"."${schema}".date_dim
  WHERE i_current_price BETWEEN 0.99 AND 1.49
    AND i_item_sk = cs_item_sk
    AND cs_warehouse_sk = w_warehouse_sk
    AND cs_sold_date_sk = d_date_sk
!   AND d_date BETWEEN (CAST ('1998-03-31' AS date) - 30 days) AND (CAST ('1998-03-31' AS date) + 30 days)
  GROUP BY w_state,
           i_item_id
  ORDER BY w_state,
           i_item_id LIMIT 100;
--- 9,18 ----
                                                                    "${database}"."${schema}".date_dim
  WHERE i_current_price BETWEEN 0.99 AND 1.49
    AND i_item_sk = cs_item_sk
    AND cs_warehouse_sk = w_warehouse_sk
    AND cs_sold_date_sk = d_date_sk
!   AND d_date BETWEEN (CAST ('1998-03-31' AS date) - INTERVAL '30' DAY) AND (CAST ('1998-03-31' AS date) + INTERVAL '30' DAY)
  GROUP BY w_state,
           i_item_id
  ORDER BY w_state,
           i_item_id LIMIT 100;