q72_modified.sql.diff

*** q72.sql	2016-03-25 14:10:21.000000000 +0100
--- q72_modified.sql	2016-03-29 11:40:05.511282538 +0200
***************
*** 16,26 ****
  LEFT OUTER JOIN "${database}"."${schema}".promotion ON (cs_promo_sk=p_promo_sk)
  LEFT OUTER JOIN "${database}"."${schema}".catalog_returns ON (cr_item_sk = cs_item_sk
                                      AND cr_order_number = cs_order_number)
  WHERE d1.d_week_seq = d2.d_week_seq
    AND inv_quantity_on_hand < cs_quantity
!   AND d3.d_date > d1.d_date + 5
    AND hd_buy_potential = '>10000'
    AND d1.d_year = 2002
    AND hd_buy_potential = '>10000'
    AND cd_marital_status = 'M'
    AND d1.d_year = 2002
--- 16,26 ----
  LEFT OUTER JOIN "${database}"."${schema}".promotion ON (cs_promo_sk=p_promo_sk)
  LEFT OUTER JOIN "${database}"."${schema}".catalog_returns ON (cr_item_sk = cs_item_sk
                                      AND cr_order_number = cs_order_number)
  WHERE d1.d_week_seq = d2.d_week_seq
    AND inv_quantity_on_hand < cs_quantity
!   AND d3.d_date > d1.d_date + INTERVAL '5' DAY
    AND hd_buy_potential = '>10000'
    AND d1.d_year = 2002
    AND hd_buy_potential = '>10000'
    AND cd_marital_status = 'M'
    AND d1.d_year = 2002
***************
*** 28,33 ****
           w_warehouse_name,
           d1.d_week_seq
  ORDER BY total_cnt DESC,
           i_item_desc,
           w_warehouse_name,
!          d_week_seq LIMIT 100;
--- 28,33 ----
           w_warehouse_name,
           d1.d_week_seq
  ORDER BY total_cnt DESC,
           i_item_desc,
           w_warehouse_name,
!          d1.d_week_seq LIMIT 100;