q94_modified.sql.diff

*** q94.sql	2016-03-25 14:10:21.910553746 +0100
--- q94_modified.sql	2016-03-25 14:10:21.910553746 +0100
***************
*** 3,13 ****
         sum(ws_net_profit) AS "total net profit"
  FROM "${database}"."${schema}".web_sales ws1 ,
       "${database}"."${schema}".date_dim ,
       "${database}"."${schema}".customer_address ,
       "${database}"."${schema}".web_site
! WHERE d_date BETWEEN '2002-3-01' AND (cast('2002-3-01' AS date) + 60 days)
    AND ws1.ws_ship_date_sk = d_date_sk
    AND ws1.ws_ship_addr_sk = ca_address_sk
    AND ca_state = 'AZ'
    AND ws1.ws_web_site_sk = web_site_sk
    AND web_company_name = 'pri'
--- 3,13 ----
         sum(ws_net_profit) AS "total net profit"
  FROM "${database}"."${schema}".web_sales ws1 ,
       "${database}"."${schema}".date_dim ,
       "${database}"."${schema}".customer_address ,
       "${database}"."${schema}".web_site
! WHERE d_date BETWEEN '2002-3-01' AND (cast('2002-3-01' AS date) + INTERVAL '60' DAY)
    AND ws1.ws_ship_date_sk = d_date_sk
    AND ws1.ws_ship_addr_sk = ca_address_sk
    AND ca_state = 'AZ'
    AND ws1.ws_web_site_sk = web_site_sk
    AND web_company_name = 'pri'