|
||||
0001 SELECT 0002 i_product_name, 0003 i_brand, 0004 i_class, 0005 i_category, 0006 avg(inv_quantity_on_hand) qoh 0007 FROM inventory, date_dim, item, warehouse 0008 WHERE inv_date_sk = d_date_sk 0009 AND inv_item_sk = i_item_sk 0010 -- q22 in TPCDS v1.4 had a condition below: 0011 -- AND inv_warehouse_sk = w_warehouse_sk 0012 AND d_month_seq BETWEEN 1200 AND 1200 + 11 0013 GROUP BY ROLLUP (i_product_name, i_brand, i_class, i_category) 0014 ORDER BY qoh, i_product_name, i_brand, i_class, i_category 0015 LIMIT 100
[ Source navigation ] | [ Diff markup ] | [ Identifier search ] | [ general search ] |
This page was automatically generated by the 2.1.0 LXR engine. The LXR team |