| -- start query 1 in stream 0 using template query22.tpl and seed 1819994127 | |
| select i_product_name | |
| ,i_brand | |
| ,i_class | |
| ,i_category | |
| ,avg(inv_quantity_on_hand) qoh | |
| from inventory | |
| ,date_dim | |
| ,item | |
| where inv_date_sk=d_date_sk | |
| and inv_item_sk=i_item_sk | |
| and d_month_seq between 1186 and 1186 + 11 | |
| group by rollup(i_product_name | |
| ,i_brand | |
| ,i_class | |
| ,i_category) | |
| order by qoh, i_product_name, i_brand, i_class, i_category | |
| limit 100; | |
| -- end query 1 in stream 0 using template query22.tpl |