q92_modified.sql

*** q92.sql	2016-03-25 14:10:21.910553746 +0100
--- q92_modified.sql	2016-03-25 14:10:21.910553746 +0100
***************
*** 2,16 ****
  FROM "${database}"."${schema}".web_sales,
       "${database}"."${schema}".item,
       "${database}"."${schema}".date_dim
  WHERE i_manufact_id = 961
    AND i_item_sk = ws_item_sk
!   AND d_date BETWEEN '2001-03-04' AND (cast('2001-03-04' AS date) + 90 days)
    AND d_date_sk = ws_sold_date_sk
    AND ws_ext_discount_amt >
      (SELECT 1.3 * avg(ws_ext_discount_amt)
       FROM "${database}"."${schema}".web_sales,
            "${database}"."${schema}".date_dim
       WHERE ws_item_sk = i_item_sk
!        AND d_date BETWEEN '2001-03-04' AND (cast('2001-03-04' AS date) + 90 days)
         AND d_date_sk = ws_sold_date_sk)
  ORDER BY sum(ws_ext_discount_amt) LIMIT 100;
--- 2,16 ----
  FROM "${database}"."${schema}".web_sales,
       "${database}"."${schema}".item,
       "${database}"."${schema}".date_dim
  WHERE i_manufact_id = 961
    AND i_item_sk = ws_item_sk
!   AND d_date BETWEEN '2001-03-04' AND (cast('2001-03-04' AS date) + INTERVAL '90' DAY)
    AND d_date_sk = ws_sold_date_sk
    AND ws_ext_discount_amt >
      (SELECT 1.3 * avg(ws_ext_discount_amt)
       FROM "${database}"."${schema}".web_sales,
            "${database}"."${schema}".date_dim
       WHERE ws_item_sk = i_item_sk
!        AND d_date BETWEEN '2001-03-04' AND (cast('2001-03-04' AS date) + INTERVAL '90' DAY)
         AND d_date_sk = ws_sold_date_sk)
  ORDER BY sum(ws_ext_discount_amt) LIMIT 100;