blob: 3fa68d2371c0281891772253db8d07160b839ead (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
--!syntax_pg
--TPC-DS Q91
-- start query 1 in stream 0 using template ../query_templates/query91.tpl
select
cc_call_center_id Call_Center,
cc_name Call_Center_Name,
cc_manager Manager,
sum(cr_net_loss) Returns_Loss
from
plato.call_center,
plato.catalog_returns,
plato.date_dim,
plato.customer,
plato.customer_address,
plato.customer_demographics,
plato.household_demographics
where
cr_call_center_sk = cc_call_center_sk
and cr_returned_date_sk = d_date_sk
and cr_returning_customer_sk= c_customer_sk
and cd_demo_sk = c_current_cdemo_sk
and hd_demo_sk = c_current_hdemo_sk
and ca_address_sk = c_current_addr_sk
and d_year = 1999
and d_moy = 11
and ( (cd_marital_status = 'M' and cd_education_status = 'Unknown')
or(cd_marital_status = 'W' and cd_education_status = 'Advanced Degree'))
and hd_buy_potential like '0-500%'
and ca_gmt_offset = -7::numeric
group by cc_call_center_id,cc_name,cc_manager,cd_marital_status,cd_education_status
order by sum(cr_net_loss) desc;
-- end query 1 in stream 0 using template ../query_templates/query91.tpl
|
