0001 SELECT
0002 i_item_id,
0003 i_item_desc,
0004 s_store_id,
0005 s_store_name,
0006 sum(ss_quantity) AS store_sales_quantity,
0007 sum(sr_return_quantity) AS store_returns_quantity,
0008 sum(cs_quantity) AS catalog_sales_quantity
0009 FROM
0010 store_sales, store_returns, catalog_sales, date_dim d1, date_dim d2,
0011 date_dim d3, store, item
0012 WHERE
0013 d1.d_moy = 9
0014 AND d1.d_year = 1999
0015 AND d1.d_date_sk = ss_sold_date_sk
0016 AND i_item_sk = ss_item_sk
0017 AND s_store_sk = ss_store_sk
0018 AND ss_customer_sk = sr_customer_sk
0019 AND ss_item_sk = sr_item_sk
0020 AND ss_ticket_number = sr_ticket_number
0021 AND sr_returned_date_sk = d2.d_date_sk
0022 AND d2.d_moy BETWEEN 9 AND 9 + 3
0023 AND d2.d_year = 1999
0024 AND sr_customer_sk = cs_bill_customer_sk
0025 AND sr_item_sk = cs_item_sk
0026 AND cs_sold_date_sk = d3.d_date_sk
0027 AND d3.d_year IN (1999, 1999 + 1, 1999 + 2)
0028 GROUP BY
0029 i_item_id, i_item_desc, s_store_id, s_store_name
0030 ORDER BY
0031 i_item_id, i_item_desc, s_store_id, s_store_name
0032 LIMIT 100