kokosing

*** q12.sql	2016-03-25 14:10:21.906553746 +0100
--- q12_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 10,20 ****
  WHERE ws_item_sk = i_item_sk
    AND i_category IN ('Men',
                       'Music',
                       'Women')
    AND ws_sold_date_sk = d_date_sk
!   AND d_date BETWEEN cast('2000-01-21' AS date) AND (cast('2000-01-21' AS date) + 30 days)

kokosing

*** q16.sql	2016-03-25 14:10:21.906553746 +0100
--- q16_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 3,13 ****
         sum(cs_net_profit) AS "total net profit"
  FROM "${database}"."${schema}".catalog_sales cs1,
       "${database}"."${schema}".date_dim,
       "${database}"."${schema}".customer_address,
       "${database}"."${schema}".call_center
! WHERE d_date BETWEEN '2001-2-01' AND (cast('2001-2-01' AS date) + 60 days)

kokosing

*** q18.sql	2016-03-25 14:10:21.906553746 +0100
--- q18_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 1,16 ****
  SELECT i_item_id,
         ca_country,
         ca_state,
         ca_county,
!        avg(cast(cs_quantity AS numeric(12,2))) agg1,
!        avg(cast(cs_list_price AS numeric(12,2))) agg2,

kokosing

*** q20.sql	2016-03-25 14:10:21.906553746 +0100
--- q20_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 10,20 ****
  WHERE cs_item_sk = i_item_sk
    AND i_category IN ('Women',
                       'Jewelry',
                       'Sports')
    AND cs_sold_date_sk = d_date_sk
!   AND d_date BETWEEN cast('2002-06-20' AS date) AND (cast('2002-06-20' AS date) + 30 days)

kokosing

*** q21.sql	2016-03-25 14:10:21.906553746 +0100
--- q21_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 10,20 ****
          "${database}"."${schema}".date_dim
     WHERE i_current_price BETWEEN 0.99 AND 1.49
       AND i_item_sk = inv_item_sk
       AND inv_warehouse_sk = w_warehouse_sk
       AND inv_date_sk = d_date_sk
!      AND d_date BETWEEN (CAST ('1999-06-23' AS date) - 30 days) AND (CAST ('1999-06-23' AS date) + 30 days)

kokosing

*** q32.sql	2016-03-25 14:10:21.906553746 +0100
--- q32_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 2,15 ****
  FROM "${database}"."${schema}".catalog_sales,
       "${database}"."${schema}".item,
       "${database}"."${schema}".date_dim
  WHERE i_manufact_id = 284
    AND i_item_sk = cs_item_sk
!   AND d_date BETWEEN '2001-01-07' AND (cast('2001-01-07' AS date) + 90 days)

kokosing

*** q37.sql	2016-03-25 14:10:21.906553746 +0100
--- q37_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 6,16 ****
       "${database}"."${schema}".date_dim,
       "${database}"."${schema}".catalog_sales
  WHERE i_current_price BETWEEN 11 AND 11 + 30
    AND inv_item_sk = i_item_sk
    AND d_date_sk=inv_date_sk
!   AND d_date BETWEEN cast('1998-01-05' AS date) AND (cast('1998-01-05' AS date) + 60 days)

kokosing

*** 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)

kokosing

*** q49.sql	2016-03-25 14:10:21.906553746 +0100
--- q49_modified.sql	2016-03-25 14:10:21.906553746 +0100
***************
*** 10,20 ****
            rank() over (
                         ORDER BY return_ratio) AS return_rank,
                                                   rank() over (
                                                                ORDER BY currency_ratio) AS currency_rank
     FROM
!      (SELECT ws.ws_item_sk AS item ,(cast(sum(coalesce(wr.wr_return_quantity,0)) AS dec(15,4))/ cast(sum(coalesce(ws.ws_quantity,0)) AS dec(15,4))) AS return_ratio ,(cast(sum(coalesce(wr.wr_return_amt,0)) AS dec(15,4))/ cast(sum(coalesce(ws.ws_net_paid,0)) AS dec(15,4))) AS currency_ratio

kokosing

*** q5.sql	2016-03-25 14:10:21.906553746 +0100
--- q5_modified.sql	2016-03-25 14:10:21.910553746 +0100
***************
*** 20,30 ****
                                                                                                                                      sr_net_loss AS net_loss
        FROM "${database}"."${schema}".store_returns) salesreturns,
          "${database}"."${schema}".date_dim,
          "${database}"."${schema}".store
     WHERE date_sk = d_date_sk
!      AND d_date BETWEEN cast('1999-08-16' AS date) AND (cast('1999-08-16' AS date) + 14 days)