Skip to content

Instantly share code, notes, and snippets.

@kokosing

kokosing/q98_modified.sql

Created March 29, 2016 07:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kokosing/73ad23a4744ea7b71083 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kokosing/73ad23a4744ea7b71083 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
q98_modified.sql
*** q98.sql 2016-03-25 14:10:21.910553746 +0100
--- q98_modified.sql 2016-03-25 14:10:21.910553746 +0100
***************
*** 10,20 ****
 WHERE ss_item_sk = i_item_sk
 AND i_category IN ('Music',
 'Men',
 'Shoes')
 AND ss_sold_date_sk = d_date_sk
! AND d_date BETWEEN cast('2001-02-24' AS date) AND (cast('2001-02-24' AS date) + 30 days)
 GROUP BY i_item_id ,
 i_item_desc,
 i_category ,
 i_class ,
 i_current_price
--- 10,20 ----
 WHERE ss_item_sk = i_item_sk
 AND i_category IN ('Music',
 'Men',
 'Shoes')
 AND ss_sold_date_sk = d_date_sk
! AND d_date BETWEEN cast('2001-02-24' AS date) AND (cast('2001-02-24' AS date) + INTERVAL '30' DAY)
 GROUP BY i_item_id ,
 i_item_desc,
 i_category ,
 i_class ,
 i_current_price
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment