| 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 CAST('100.00' AS DECIMAL(5,2)) AND CAST('150.00' AS DECIMAL(5,2)))) |
| OR ((cd_demo_sk = ss_cdemo_sk) |
| AND (cd_marital_status = 'D') |
| AND (cd_education_status = '2 yr Degree') |
| AND (ss_sales_price BETWEEN CAST('50.00' AS DECIMAL(5,2)) AND CAST('100.00' AS DECIMAL(5,2)))) |
| OR ((cd_demo_sk = ss_cdemo_sk) |
| AND (cd_marital_status = 'S') |
| AND (cd_education_status = 'College') |
| AND (ss_sales_price BETWEEN CAST('150.00' AS DECIMAL(5,2)) AND CAST('200.00' AS DECIMAL(5,2))))) |
| 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))) |