tpcds.query48.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 sum(ss_quantity)
from store_sales,
store,
customer_demographics,
customer_address,
date_dim
where s_store_sk = ss_store_sk
and ss_sold_date_sk = d_date_sk
and d_year = 2000
and (
(
cd_demo_sk = ss_cdemo_sk
and
cd_marital_status = 'M'
and
cd_education_status = '4 yr Degree'
and
ss_sales_price between 100.00 and 150.00
)
or
(
cd_demo_sk = ss_cdemo_sk
and
cd_marital_status = 'D'
and
cd_education_status = '2 yr Degree'
and
ss_sales_price between 50.00 and 100.00
)
or
(
cd_demo_sk = ss_cdemo_sk
and
cd_marital_status = 'S'
and
cd_education_status = 'College'
and
ss_sales_price between 150.00 and 200.00
)
)
and (
(
ss_addr_sk = ca_address_sk
and
ca_country = 'United States'
and
ca_state in ('CO', 'OH', 'TX')
and ss_net_profit between 0 and 2000
)
or
(ss_addr_sk = ca_address_sk
and
ca_country = 'United States'
and
ca_state in ('OR', 'MN', 'KY')
and ss_net_profit between 150 and 3000
)
or
(ss_addr_sk = ca_address_sk
and
ca_country = 'United States'
and
ca_state in ('VA', 'CA', 'MS')
and ss_net_profit between 50 and 25000
)
)