mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
15 lines
385 B
SQL
15 lines
385 B
SQL
SELECT
|
|
i_product_name,
|
|
i_brand,
|
|
i_class,
|
|
i_category,
|
|
avg(inv_quantity_on_hand) AS 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 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;
|
|
|