testdata/workloads/tpcds-unmodified/queries/tpcds-q35.test

====
---- QUERY: TPCDS-Q35

with bla as (select
ss_customer_sk as customer_sk
from
store_sales,
date_dim
where
ss_sold_date_sk = d_date_sk
and d_year = 1999
and d_qoy < 4
group by ss_customer_sk union all select
ws_bill_customer_sk as customer_sk
from
web_sales,
date_dim
where
ws_sold_date_sk = d_date_sk
and d_year = 1999
and d_qoy < 4
group by ws_bill_customer_sk union all select
cs_ship_customer_sk customer_sk
from
catalog_sales,
date_dim
where
cs_sold_date_sk = d_date_sk
and d_year = 1999
and d_qoy < 4
group by cs_ship_customer_sk)
select
ca_state,
cd_gender,
cd_marital_status,
cd_dep_count,
count(*) cnt1,
avg(cd_dep_count),
max(cd_dep_count),
sum(cd_dep_count),
cd_dep_employed_count,
count(*) cnt2,
avg(cd_dep_employed_count),
max(cd_dep_employed_count),
sum(cd_dep_employed_count),
cd_dep_college_count,
count(*) cnt3,
avg(cd_dep_college_count),
max(cd_dep_college_count),
sum(cd_dep_college_count)
from
customer c,
customer_address ca,
customer_demographics cd,
bla
where
c.c_current_addr_sk = ca.ca_address_sk
and cd_demo_sk = c.c_current_cdemo_sk
and c.c_customer_sk = bla.customer_sk
group by ca_state , cd_gender , cd_marital_status , cd_dep_count , cd_dep_employed_count , cd_dep_college_count
order by ca_state , cd_gender , cd_marital_status , cd_dep_count , cd_dep_employed_count , cd_dep_college_count
limit 100;
---- RESULTS
---- TYPES
INT, INT, STRING, DECIMAL
====