Skip to content

Instantly share code, notes, and snippets.

@kokosing

kokosing/q95_modified.sql

Created March 29, 2016 07:31
Show Gist options
  • Save kokosing/33e1cfdd2b05ca3fbf5f to your computer and use it in GitHub Desktop.
Save kokosing/33e1cfdd2b05ca3fbf5f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
q95_modified.sql
*** q95.sql 2016-03-25 14:10:21.910553746 +0100
--- q95_modified.sql 2016-03-25 14:10:21.910553746 +0100
***************
*** 11,21 ****
 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 '2000-5-01' AND (cast('2000-5-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 = 'TN'
 AND ws1.ws_web_site_sk = web_site_sk
 AND web_company_name = 'pri'
--- 11,21 ----
 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 '2000-5-01' AND (cast('2000-5-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 = 'TN'
 AND ws1.ws_web_site_sk = web_site_sk
 AND web_company_name = 'pri'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment