blob: add3b41f7c76c6e61b0dcaf1717d6eebc15c744f (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
SELECT
i_product_name,
i_brand,
i_class,
i_category,
avg(inv_quantity_on_hand) qoh
FROM inventory, date_dim, item, warehouse
WHERE inv_date_sk = d_date_sk
AND inv_item_sk = i_item_sk
AND inv_warehouse_sk = w_warehouse_sk
AND d_month_seq BETWEEN 1200 AND 1200 + 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
|