0001 SELECT
0002 i_item_id,
0003 i_item_desc,
0004 s_store_id,
0005 s_store_name,
0006 sum(ss_net_profit) AS store_sales_profit,
0007 sum(sr_net_loss) AS store_returns_loss,
0008 sum(cs_net_profit) AS catalog_sales_profit
0009 FROM
0010 store_sales, store_returns, catalog_sales, date_dim d1, date_dim d2, date_dim d3,
0011 store, item
0012 WHERE
0013 d1.d_moy = 4
0014 AND d1.d_year = 2001
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 4 AND 10
0023 AND d2.d_year = 2001
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_moy BETWEEN 4 AND 10
0028 AND d3.d_year = 2001
0029 GROUP BY
0030 i_item_id, i_item_desc, s_store_id, s_store_name
0031 ORDER BY
0032 i_item_id, i_item_desc, s_store_id, s_store_name
0033 LIMIT 100
