q5_modified.sql.diff

*** 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)
       AND store_sk = s_store_sk
     GROUP BY s_store_id),
       csr AS
    (SELECT cp_catalog_page_id,
            sum(sales_price) AS sales,
--- 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) + INTERVAL '14' DAY)
       AND store_sk = s_store_sk
     GROUP BY s_store_id),
       csr AS
    (SELECT cp_catalog_page_id,
            sum(sales_price) AS sales,
***************
*** 47,57 ****
                                                                                                                                                cr_net_loss AS net_loss
        FROM "${database}"."${schema}".catalog_returns) salesreturns,
          "${database}"."${schema}".date_dim,
          "${database}"."${schema}".catalog_page
     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)
       AND page_sk = cp_catalog_page_sk
     GROUP BY cp_catalog_page_id),
       wsr AS
    (SELECT web_site_id,
            sum(sales_price) AS sales,
--- 47,57 ----
                                                                                                                                                cr_net_loss AS net_loss
        FROM "${database}"."${schema}".catalog_returns) salesreturns,
          "${database}"."${schema}".date_dim,
          "${database}"."${schema}".catalog_page
     WHERE date_sk = d_date_sk
!      AND d_date BETWEEN cast('1999-08-16' AS date) AND (cast('1999-08-16' AS date) + INTERVAL '14' DAY)
       AND page_sk = cp_catalog_page_sk
     GROUP BY cp_catalog_page_id),
       wsr AS
    (SELECT web_site_id,
            sum(sales_price) AS sales,
***************
*** 76,86 ****
        LEFT OUTER JOIN "${database}"."${schema}".web_sales ON (wr_item_sk = ws_item_sk
                                      AND wr_order_number = ws_order_number)) salesreturns,
          "${database}"."${schema}".date_dim,
          "${database}"."${schema}".web_site
     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)
       AND wsr_web_site_sk = web_site_sk
     GROUP BY web_site_id)
  SELECT channel,
         id,
         sum(sales) AS sales,
--- 76,86 ----
        LEFT OUTER JOIN "${database}"."${schema}".web_sales ON (wr_item_sk = ws_item_sk
                                      AND wr_order_number = ws_order_number)) salesreturns,
          "${database}"."${schema}".date_dim,
          "${database}"."${schema}".web_site
     WHERE date_sk = d_date_sk
!      AND d_date BETWEEN cast('1999-08-16' AS date) AND (cast('1999-08-16' AS date) + INTERVAL '14' DAY)
       AND wsr_web_site_sk = web_site_sk
     GROUP BY web_site_id)
  SELECT channel,
         id,
         sum(sales) AS sales,