0001 SELECT sum(ss_quantity)
0002 FROM store_sales, store, customer_demographics, customer_address, date_dim
0003 WHERE s_store_sk = ss_store_sk
0004 AND ss_sold_date_sk = d_date_sk AND d_year = 2001
0005 AND
0006 (
0007 (
0008 cd_demo_sk = ss_cdemo_sk
0009 AND
0010 cd_marital_status = 'M'
0011 AND
0012 cd_education_status = '4 yr Degree'
0013 AND
0014 ss_sales_price BETWEEN 100.00 AND 150.00
0015 )
0016 OR
0017 (
0018 cd_demo_sk = ss_cdemo_sk
0019 AND
0020 cd_marital_status = 'D'
0021 AND
0022 cd_education_status = '2 yr Degree'
0023 AND
0024 ss_sales_price BETWEEN 50.00 AND 100.00
0025 )
0026 OR
0027 (
0028 cd_demo_sk = ss_cdemo_sk
0029 AND
0030 cd_marital_status = 'S'
0031 AND
0032 cd_education_status = 'College'
0033 AND
0034 ss_sales_price BETWEEN 150.00 AND 200.00
0035 )
0036 )
0037 AND
0038 (
0039 (
0040 ss_addr_sk = ca_address_sk
0041 AND
0042 ca_country = 'United States'
0043 AND
0044 ca_state IN ('CO', 'OH', 'TX')
0045 AND ss_net_profit BETWEEN 0 AND 2000
0046 )
0047 OR
0048 (ss_addr_sk = ca_address_sk
0049 AND
0050 ca_country = 'United States'
0051 AND
0052 ca_state IN ('OR', 'MN', 'KY')
0053 AND ss_net_profit BETWEEN 150 AND 3000
0054 )
0055 OR
0056 (ss_addr_sk = ca_address_sk
0057 AND
0058 ca_country = 'United States'
0059 AND
0060 ca_state IN ('VA', 'CA', 'MS')
0061 AND ss_net_profit BETWEEN 50 AND 25000
0062 )
0063 )
