0001 SELECT
0002 avg(ss_quantity),
0003 avg(ss_ext_sales_price),
0004 avg(ss_ext_wholesale_cost),
0005 sum(ss_ext_wholesale_cost)
0006 FROM store_sales
0007 , store
0008 , customer_demographics
0009 , household_demographics
0010 , customer_address
0011 , date_dim
0012 WHERE s_store_sk = ss_store_sk
0013 AND ss_sold_date_sk = d_date_sk AND d_year = 2001
0014 AND ((ss_hdemo_sk = hd_demo_sk
0015 AND cd_demo_sk = ss_cdemo_sk
0016 AND cd_marital_status = 'M'
0017 AND cd_education_status = 'Advanced Degree'
0018 AND ss_sales_price BETWEEN 100.00 AND 150.00
0019 AND hd_dep_count = 3
0020 ) OR
0021 (ss_hdemo_sk = hd_demo_sk
0022 AND cd_demo_sk = ss_cdemo_sk
0023 AND cd_marital_status = 'S'
0024 AND cd_education_status = 'College'
0025 AND ss_sales_price BETWEEN 50.00 AND 100.00
0026 AND hd_dep_count = 1
0027 ) OR
0028 (ss_hdemo_sk = hd_demo_sk
0029 AND cd_demo_sk = ss_cdemo_sk
0030 AND cd_marital_status = 'W'
0031 AND cd_education_status = '2 yr Degree'
0032 AND ss_sales_price BETWEEN 150.00 AND 200.00
0033 AND hd_dep_count = 1
0034 ))
0035 AND ((ss_addr_sk = ca_address_sk
0036 AND ca_country = 'United States'
0037 AND ca_state IN ('TX', 'OH', 'TX')
0038 AND ss_net_profit BETWEEN 100 AND 200
0039 ) OR
0040 (ss_addr_sk = ca_address_sk
0041 AND ca_country = 'United States'
0042 AND ca_state IN ('OR', 'NM', 'KY')
0043 AND ss_net_profit BETWEEN 150 AND 300
0044 ) OR
0045 (ss_addr_sk = ca_address_sk
0046 AND ca_country = 'United States'
0047 AND ca_state IN ('VA', 'TX', 'MS')
0048 AND ss_net_profit BETWEEN 50 AND 250
0049 ))