Skip to content

Instantly share code, notes, and snippets.

@kokosing

kokosing/q40_modified.sql

Created March 29, 2016 07:31
Show Gist options
  • Save kokosing/3b79ced0a9b1563d81df to your computer and use it in GitHub Desktop.
Save kokosing/3b79ced0a9b1563d81df to your computer and use it in GitHub Desktop.
Download ZIP
Raw
q40_modified.sql
*** q40.sql 2016-03-25 14:10:21.906553746 +0100
--- q40_modified.sql 2016-03-25 14:10:21.906553746 +0100
***************
*** 9,18 ****
 "${database}"."${schema}".date_dim
 WHERE i_current_price BETWEEN 0.99 AND 1.49
 AND i_item_sk = cs_item_sk
 AND cs_warehouse_sk = w_warehouse_sk
 AND cs_sold_date_sk = d_date_sk
! AND d_date BETWEEN (CAST ('1998-03-31' AS date) - 30 days) AND (CAST ('1998-03-31' AS date) + 30 days)
 GROUP BY w_state,
 i_item_id
 ORDER BY w_state,
 i_item_id LIMIT 100;
--- 9,18 ----
 "${database}"."${schema}".date_dim
 WHERE i_current_price BETWEEN 0.99 AND 1.49
 AND i_item_sk = cs_item_sk
 AND cs_warehouse_sk = w_warehouse_sk
 AND cs_sold_date_sk = d_date_sk
! AND d_date BETWEEN (CAST ('1998-03-31' AS date) - INTERVAL '30' DAY) AND (CAST ('1998-03-31' AS date) + INTERVAL '30' DAY)
 GROUP BY w_state,
 i_item_id
 ORDER BY w_state,
 i_item_id LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment