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