0001 SELECT
0002 cd_gender,
0003 cd_marital_status,
0004 cd_education_status,
0005 count(*) cnt1,
0006 cd_purchase_estimate,
0007 count(*) cnt2,
0008 cd_credit_rating,
0009 count(*) cnt3,
0010 cd_dep_count,
0011 count(*) cnt4,
0012 cd_dep_employed_count,
0013 count(*) cnt5,
0014 cd_dep_college_count,
0015 count(*) cnt6
0016 FROM
0017 customer c, customer_address ca, customer_demographics
0018 WHERE
0019 c.c_current_addr_sk = ca.ca_address_sk AND
0020 ca_county IN ('Rush County', 'Toole County', 'Jefferson County',
0021 'Dona Ana County', 'La Porte County') AND
0022 cd_demo_sk = c.c_current_cdemo_sk AND
0023 exists(SELECT *
0024 FROM store_sales, date_dim
0025 WHERE c.c_customer_sk = ss_customer_sk AND
0026 ss_sold_date_sk = d_date_sk AND
0027 d_year = 2002 AND
0028 d_moy BETWEEN 1 AND 1 + 3) AND
0029 (exists(SELECT *
0030 FROM web_sales, date_dim
0031 WHERE c.c_customer_sk = ws_bill_customer_sk AND
0032 ws_sold_date_sk = d_date_sk AND
0033 d_year = 2002 AND
0034 d_moy BETWEEN 1 AND 1 + 3) OR
0035 exists(SELECT *
0036 FROM catalog_sales, date_dim
0037 WHERE c.c_customer_sk = cs_ship_customer_sk AND
0038 cs_sold_date_sk = d_date_sk AND
0039 d_year = 2002 AND
0040 d_moy BETWEEN 1 AND 1 + 3))
0041 GROUP BY cd_gender,
0042 cd_marital_status,
0043 cd_education_status,
0044 cd_purchase_estimate,
0045 cd_credit_rating,
0046 cd_dep_count,
0047 cd_dep_employed_count,
0048 cd_dep_college_count
0049 ORDER BY cd_gender,
0050 cd_marital_status,
0051 cd_education_status,
0052 cd_purchase_estimate,
0053 cd_credit_rating,
0054 cd_dep_count,
0055 cd_dep_employed_count,
0056 cd_dep_college_count
0057 LIMIT 100
