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 FROM
0011 customer c, customer_address ca, customer_demographics
0012 WHERE
0013 c.c_current_addr_sk = ca.ca_address_sk AND
0014 ca_state IN ('KY', 'GA', 'NM') AND
0015 cd_demo_sk = c.c_current_cdemo_sk AND
0016 exists(SELECT *
0017 FROM store_sales, date_dim
0018 WHERE c.c_customer_sk = ss_customer_sk AND
0019 ss_sold_date_sk = d_date_sk AND
0020 d_year = 2001 AND
0021 d_moy BETWEEN 4 AND 4 + 2) AND
0022 (NOT exists(SELECT *
0023 FROM web_sales, date_dim
0024 WHERE c.c_customer_sk = ws_bill_customer_sk AND
0025 ws_sold_date_sk = d_date_sk AND
0026 d_year = 2001 AND
0027 d_moy BETWEEN 4 AND 4 + 2) AND
0028 NOT exists(SELECT *
0029 FROM catalog_sales, date_dim
0030 WHERE c.c_customer_sk = cs_ship_customer_sk AND
0031 cs_sold_date_sk = d_date_sk AND
0032 d_year = 2001 AND
0033 d_moy BETWEEN 4 AND 4 + 2))
0034 GROUP BY cd_gender, cd_marital_status, cd_education_status,
0035 cd_purchase_estimate, cd_credit_rating
0036 ORDER BY cd_gender, cd_marital_status, cd_education_status,
0037 cd_purchase_estimate, cd_credit_rating
0038 LIMIT 100
