| ==== |
| ---- QUERY: TPCDS-Q48 |
| 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 |
| ) |
| ) |
| ---- RESULTS |
| 26257 |
| ---- TYPES |
| BIGINT |
| ==== |