tpcds.query10.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of druid Show documentation
Show all versions of druid Show documentation
An JDBC datasource implementation.
select cd_gender,
cd_marital_status,
cd_education_status,
count(*) cnt1,
cd_purchase_estimate,
count(*) cnt2,
cd_credit_rating,
count(*) cnt3,
cd_dep_count,
count(*) cnt4,
cd_dep_employed_count,
count(*) cnt5,
cd_dep_college_count,
count(*) cnt6
from customer c,
customer_address ca,
customer_demographics
where c.c_current_addr_sk = ca.ca_address_sk
and ca_county in ('Rush County', 'Toole County', 'Jefferson County', 'Dona Ana County', 'La Porte County')
and cd_demo_sk = c.c_current_cdemo_sk
and exists(select *
from store_sales,
date_dim
where c.c_customer_sk = ss_customer_sk
and ss_sold_date_sk = d_date_sk
and d_year = 2002
and d_moy between 1 and 1 + 3)
and (exists(select *
from web_sales,
date_dim
where c.c_customer_sk = ws_bill_customer_sk
and ws_sold_date_sk = d_date_sk
and d_year = 2002
and d_moy between 1 ANd 1 + 3) or
exists(select *
from catalog_sales,
date_dim
where c.c_customer_sk = cs_ship_customer_sk
and cs_sold_date_sk = d_date_sk
and d_year = 2002
and d_moy between 1 and 1 + 3))
group by cd_gender,
cd_marital_status,
cd_education_status,
cd_purchase_estimate,
cd_credit_rating,
cd_dep_count,
cd_dep_employed_count,
cd_dep_college_count
order by cd_gender,
cd_marital_status,
cd_education_status,
cd_purchase_estimate,
cd_credit_rating,
cd_dep_count,
cd_dep_employed_count,
cd_dep_college_count limit 100