Created
March 29, 2016 07:31
-
-
Save kokosing/306d43e8dd1801994abe to your computer and use it in GitHub Desktop.
This file contains 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*** q16.sql 2016-03-25 14:10:21.906553746 +0100[0;0m | |
| [1;34m--- q16_modified.sql 2016-03-25 14:10:21.906553746 +0100[0;0m | |
| [1;35m***************[0;0m | |
| [1;35m*** 3,13 ****[0;0m | |
| [0;0m sum(cs_net_profit) AS "total net profit"[0;0m | |
| [0;0m FROM "${database}"."${schema}".catalog_sales cs1,[0;0m | |
| [0;0m "${database}"."${schema}".date_dim,[0;0m | |
| [0;0m "${database}"."${schema}".customer_address,[0;0m | |
| [0;0m "${database}"."${schema}".call_center[0;0m | |
| [1;31m! WHERE d_date BETWEEN '2001-2-01' AND (cast('2001-2-01' AS date) + 60 days)[0;0m | |
| [0;0m AND cs1.cs_ship_date_sk = d_date_sk[0;0m | |
| [0;0m AND cs1.cs_ship_addr_sk = ca_address_sk[0;0m | |
| [0;0m AND ca_state = 'TX'[0;0m | |
| [0;0m AND cs1.cs_call_center_sk = cc_call_center_sk[0;0m | |
| [0;0m AND cc_county IN ('Fairfield County',[0;0m | |
| [1;35m--- 3,13 ----[0;0m | |
| [0;0m sum(cs_net_profit) AS "total net profit"[0;0m | |
| [0;0m FROM "${database}"."${schema}".catalog_sales cs1,[0;0m | |
| [0;0m "${database}"."${schema}".date_dim,[0;0m | |
| [0;0m "${database}"."${schema}".customer_address,[0;0m | |
| [0;0m "${database}"."${schema}".call_center[0;0m | |
| [1;34m! WHERE d_date BETWEEN '2001-2-01' AND (cast('2001-2-01' AS date) + INTERVAL '60' DAY)[0;0m | |
| [0;0m AND cs1.cs_ship_date_sk = d_date_sk[0;0m | |
| [0;0m AND cs1.cs_ship_addr_sk = ca_address_sk[0;0m | |
| [0;0m AND ca_state = 'TX'[0;0m | |
| [0;0m AND cs1.cs_call_center_sk = cc_call_center_sk[0;0m | |
| [0;0m AND cc_county IN ('Fairfield County',[0;0m |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment