q80_modified.sql

*** q80.sql	2016-03-25 14:10:21.910553746 +0100
--- q80_modified.sql	2016-03-25 14:10:21.910553746 +0100
***************
*** 8,18 ****
                                       AND ss_ticket_number = sr_ticket_number), "${database}"."${schema}".date_dim,
                                                                                 "${database}"."${schema}".store,
                                                                                 "${database}"."${schema}".item,
                                                                                 "${database}"."${schema}".promotion
     WHERE ss_sold_date_sk = d_date_sk
!      AND d_date BETWEEN cast('2002-08-05' AS date) AND (cast('2002-08-05' AS date) + 30 days)
       AND ss_store_sk = s_store_sk
       AND ss_item_sk = i_item_sk
       AND i_current_price > 50
       AND ss_promo_sk = p_promo_sk
       AND p_channel_tv = 'N'
--- 8,18 ----
                                       AND ss_ticket_number = sr_ticket_number), "${database}"."${schema}".date_dim,
                                                                                 "${database}"."${schema}".store,
                                                                                 "${database}"."${schema}".item,
                                                                                 "${database}"."${schema}".promotion
     WHERE ss_sold_date_sk = d_date_sk
!      AND d_date BETWEEN cast('2002-08-05' AS date) AND (cast('2002-08-05' AS date) + INTERVAL '30' DAY)
       AND ss_store_sk = s_store_sk
       AND ss_item_sk = i_item_sk
       AND i_current_price > 50
       AND ss_promo_sk = p_promo_sk
       AND p_channel_tv = 'N'
***************
*** 27,37 ****
                                         AND cs_order_number = cr_order_number), "${database}"."${schema}".date_dim,
                                                                                 "${database}"."${schema}".catalog_page,
                                                                                 "${database}"."${schema}".item,
                                                                                 "${database}"."${schema}".promotion
     WHERE cs_sold_date_sk = d_date_sk
!      AND d_date BETWEEN cast('2002-08-05' AS date) AND (cast('2002-08-05' AS date) + 30 days)
       AND cs_catalog_page_sk = cp_catalog_page_sk
       AND cs_item_sk = i_item_sk
       AND i_current_price > 50
       AND cs_promo_sk = p_promo_sk
       AND p_channel_tv = 'N'
--- 27,37 ----
                                         AND cs_order_number = cr_order_number), "${database}"."${schema}".date_dim,
                                                                                 "${database}"."${schema}".catalog_page,
                                                                                 "${database}"."${schema}".item,
                                                                                 "${database}"."${schema}".promotion
     WHERE cs_sold_date_sk = d_date_sk
!      AND d_date BETWEEN cast('2002-08-05' AS date) AND (cast('2002-08-05' AS date) + INTERVAL '30' DAY)
       AND cs_catalog_page_sk = cp_catalog_page_sk
       AND cs_item_sk = i_item_sk
       AND i_current_price > 50
       AND cs_promo_sk = p_promo_sk
       AND p_channel_tv = 'N'
***************
*** 46,56 ****
                                     AND ws_order_number = wr_order_number), "${database}"."${schema}".date_dim,
                                                                             "${database}"."${schema}".web_site,
                                                                             "${database}"."${schema}".item,
                                                                             "${database}"."${schema}".promotion
     WHERE ws_sold_date_sk = d_date_sk
!      AND d_date BETWEEN cast('2002-08-05' AS date) AND (cast('2002-08-05' AS date) + 30 days)
       AND ws_web_site_sk = web_site_sk
       AND ws_item_sk = i_item_sk
       AND i_current_price > 50
       AND ws_promo_sk = p_promo_sk
       AND p_channel_tv = 'N'
--- 46,56 ----
                                     AND ws_order_number = wr_order_number), "${database}"."${schema}".date_dim,
                                                                             "${database}"."${schema}".web_site,
                                                                             "${database}"."${schema}".item,
                                                                             "${database}"."${schema}".promotion
     WHERE ws_sold_date_sk = d_date_sk
!      AND d_date BETWEEN cast('2002-08-05' AS date) AND (cast('2002-08-05' AS date) + INTERVAL '30' DAY)
       AND ws_web_site_sk = web_site_sk
       AND ws_item_sk = i_item_sk
       AND i_current_price > 50
       AND ws_promo_sk = p_promo_sk
       AND p_channel_tv = 'N'