0001 SELECT count(*)
0002 FROM ((SELECT DISTINCT
0003 c_last_name,
0004 c_first_name,
0005 d_date
0006 FROM store_sales, date_dim, customer
0007 WHERE store_sales.ss_sold_date_sk = date_dim.d_date_sk
0008 AND store_sales.ss_customer_sk = customer.c_customer_sk
0009 AND d_month_seq BETWEEN 1200 AND 1200 + 11)
0010 EXCEPT
0011 (SELECT DISTINCT
0012 c_last_name,
0013 c_first_name,
0014 d_date
0015 FROM catalog_sales, date_dim, customer
0016 WHERE catalog_sales.cs_sold_date_sk = date_dim.d_date_sk
0017 AND catalog_sales.cs_bill_customer_sk = customer.c_customer_sk
0018 AND d_month_seq BETWEEN 1200 AND 1200 + 11)
0019 EXCEPT
0020 (SELECT DISTINCT
0021 c_last_name,
0022 c_first_name,
0023 d_date
0024 FROM web_sales, date_dim, customer
0025 WHERE web_sales.ws_sold_date_sk = date_dim.d_date_sk
0026 AND web_sales.ws_bill_customer_sk = customer.c_customer_sk
0027 AND d_month_seq BETWEEN 1200 AND 1200 + 11)
0028 ) cool_cust
