kokosing
/ q32_modified.sql.diff
Created
March 29, 2016 07:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *** q32.sql 2016-03-25 14:10:21.906553746 +0100 | |
| --- q32_modified.sql 2016-03-25 14:10:21.906553746 +0100 | |
| *************** | |
| *** 2,15 **** | |
| FROM "${database}"."${schema}".catalog_sales, | |
| "${database}"."${schema}".item, | |
| "${database}"."${schema}".date_dim | |
| WHERE i_manufact_id = 284 | |
| AND i_item_sk = cs_item_sk | |
| ! AND d_date BETWEEN '2001-01-07' AND (cast('2001-01-07' AS date) + 90 days) |
kokosing
/ q21_modified.sql.diff
Created
March 29, 2016 07:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *** q21.sql 2016-03-25 14:10:21.906553746 +0100 | |
| --- q21_modified.sql 2016-03-25 14:10:21.906553746 +0100 | |
| *************** | |
| *** 10,20 **** | |
| "${database}"."${schema}".date_dim | |
| WHERE i_current_price BETWEEN 0.99 AND 1.49 | |
| AND i_item_sk = inv_item_sk | |
| AND inv_warehouse_sk = w_warehouse_sk | |
| AND inv_date_sk = d_date_sk | |
| ! AND d_date BETWEEN (CAST ('1999-06-23' AS date) - 30 days) AND (CAST ('1999-06-23' AS date) + 30 days) |
kokosing
/ q20_modified.sql.diff
Created
March 29, 2016 07:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *** q20.sql 2016-03-25 14:10:21.906553746 +0100 | |
| --- q20_modified.sql 2016-03-25 14:10:21.906553746 +0100 | |
| *************** | |
| *** 10,20 **** | |
| WHERE cs_item_sk = i_item_sk | |
| AND i_category IN ('Women', | |
| 'Jewelry', | |
| 'Sports') | |
| AND cs_sold_date_sk = d_date_sk | |
| ! AND d_date BETWEEN cast('2002-06-20' AS date) AND (cast('2002-06-20' AS date) + 30 days) |
kokosing
/ q18_modified.sql.diff
Created
March 29, 2016 07:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *** q18.sql 2016-03-25 14:10:21.906553746 +0100 | |
| --- q18_modified.sql 2016-03-25 14:10:21.906553746 +0100 | |
| *************** | |
| *** 1,16 **** | |
| SELECT i_item_id, | |
| ca_country, | |
| ca_state, | |
| ca_county, | |
| ! avg(cast(cs_quantity AS numeric(12,2))) agg1, | |
| ! avg(cast(cs_list_price AS numeric(12,2))) agg2, |
kokosing
/ q16_modified.sql.diff
Created
March 29, 2016 07:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *** q16.sql 2016-03-25 14:10:21.906553746 +0100 | |
| --- q16_modified.sql 2016-03-25 14:10:21.906553746 +0100 | |
| *************** | |
| *** 3,13 **** | |
| sum(cs_net_profit) AS "total net profit" | |
| FROM "${database}"."${schema}".catalog_sales cs1, | |
| "${database}"."${schema}".date_dim, | |
| "${database}"."${schema}".customer_address, | |
| "${database}"."${schema}".call_center | |
| ! WHERE d_date BETWEEN '2001-2-01' AND (cast('2001-2-01' AS date) + 60 days) |
kokosing
/ q12_modified.sql.diff
Created
March 29, 2016 07:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *** q12.sql 2016-03-25 14:10:21.906553746 +0100 | |
| --- q12_modified.sql 2016-03-25 14:10:21.906553746 +0100 | |
| *************** | |
| *** 10,20 **** | |
| WHERE ws_item_sk = i_item_sk | |
| AND i_category IN ('Men', | |
| 'Music', | |
| 'Women') | |
| AND ws_sold_date_sk = d_date_sk | |
| ! AND d_date BETWEEN cast('2000-01-21' AS date) AND (cast('2000-01-21' AS date) + 30 days) |
kokosing
/ q98_modified.sql
Created
March 29, 2016 07:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [1;31m*** q98.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;34m--- q98_modified.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;35m***************[0;0m | |
| [1;35m*** 10,20 ****[0;0m | |
| [0;0m WHERE ss_item_sk = i_item_sk[0;0m | |
| [0;0m AND i_category IN ('Music',[0;0m | |
| [0;0m 'Men',[0;0m | |
| [0;0m 'Shoes')[0;0m | |
| [0;0m AND ss_sold_date_sk = d_date_sk[0;0m | |
| [1;31m! AND d_date BETWEEN cast('2001-02-24' AS date) AND (cast('2001-02-24' AS date) + 30 days)[0;0m |
kokosing
/ q95_modified.sql
Created
March 29, 2016 07:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [1;31m*** q95.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;34m--- q95_modified.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;35m***************[0;0m | |
| [1;35m*** 11,21 ****[0;0m | |
| [0;0m sum(ws_net_profit) AS "total net profit"[0;0m | |
| [0;0m FROM "${database}"."${schema}".web_sales ws1 ,[0;0m | |
| [0;0m "${database}"."${schema}".date_dim ,[0;0m | |
| [0;0m "${database}"."${schema}".customer_address ,[0;0m | |
| [0;0m "${database}"."${schema}".web_site[0;0m | |
| [1;31m! WHERE d_date BETWEEN '2000-5-01' AND (cast('2000-5-01' AS date) + 60 days)[0;0m |
kokosing
/ q94_modified.sql
Created
March 29, 2016 07:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [1;31m*** q94.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;34m--- q94_modified.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;35m***************[0;0m | |
| [1;35m*** 3,13 ****[0;0m | |
| [0;0m sum(ws_net_profit) AS "total net profit"[0;0m | |
| [0;0m FROM "${database}"."${schema}".web_sales ws1 ,[0;0m | |
| [0;0m "${database}"."${schema}".date_dim ,[0;0m | |
| [0;0m "${database}"."${schema}".customer_address ,[0;0m | |
| [0;0m "${database}"."${schema}".web_site[0;0m | |
| [1;31m! WHERE d_date BETWEEN '2002-3-01' AND (cast('2002-3-01' AS date) + 60 days)[0;0m |
kokosing
/ q92_modified.sql
Created
March 29, 2016 07:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [1;31m*** q92.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;34m--- q92_modified.sql 2016-03-25 14:10:21.910553746 +0100[0;0m | |
| [1;35m***************[0;0m | |
| [1;35m*** 2,16 ****[0;0m | |
| [0;0m FROM "${database}"."${schema}".web_sales,[0;0m | |
| [0;0m "${database}"."${schema}".item,[0;0m | |
| [0;0m "${database}"."${schema}".date_dim[0;0m | |
| [0;0m WHERE i_manufact_id = 961[0;0m | |
| [0;0m AND i_item_sk = ws_item_sk[0;0m | |
| [1;31m! AND d_date BETWEEN '2001-03-04' AND (cast('2001-03-04' AS date) + 90 days)[0;0m |