projects / ceph.git / blame
| Commit | Line | Data |
|---|---|---|
| aee94f69 TL |
1 | -- start query 1 in stream 0 using template query25.tpl and seed 1819994127 |
| 2 | select | |
| 3 | i_item_id | |
| 4 | ,i_item_desc | |
| 5 | ,s_store_id | |
| 6 | ,s_store_name | |
| 7 | ,sum(ss_net_profit) as store_sales_profit | |
| 8 | ,sum(sr_net_loss) as store_returns_loss | |
| 9 | ,sum(cs_net_profit) as catalog_sales_profit | |
| 10 | from | |
| 11 | store_sales | |
| 12 | ,store_returns | |
| 13 | ,catalog_sales | |
| 14 | ,date_dim d1 | |
| 15 | ,date_dim d2 | |
| 16 | ,date_dim d3 | |
| 17 | ,store | |
| 18 | ,item | |
| 19 | where | |
| 20 | d1.d_moy = 4 | |
| 21 | and d1.d_year = 2000 | |
| 22 | and d1.d_date_sk = ss_sold_date_sk | |
| 23 | and i_item_sk = ss_item_sk | |
| 24 | and s_store_sk = ss_store_sk | |
| 25 | and ss_customer_sk = sr_customer_sk | |
| 26 | and ss_item_sk = sr_item_sk | |
| 27 | and ss_ticket_number = sr_ticket_number | |
| 28 | and sr_returned_date_sk = d2.d_date_sk | |
| 29 | and d2.d_moy between 4 and 10 | |
| 30 | and d2.d_year = 2000 | |
| 31 | and sr_customer_sk = cs_bill_customer_sk | |
| 32 | and sr_item_sk = cs_item_sk | |
| 33 | and cs_sold_date_sk = d3.d_date_sk | |
| 34 | and d3.d_moy between 4 and 10 | |
| 35 | and d3.d_year = 2000 | |
| 36 | group by | |
| 37 | i_item_id | |
| 38 | ,i_item_desc | |
| 39 | ,s_store_id | |
| 40 | ,s_store_name | |
| 41 | order by | |
| 42 | i_item_id | |
| 43 | ,i_item_desc | |
| 44 | ,s_store_id | |
| 45 | ,s_store_name | |
| 46 | limit 100; | |
| 47 | ||
| 48 | -- end query 1 in stream 0 using template query25.tpl |