blob: 889168511b688c7551ab91ea1060b9e97be1d569 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
--!syntax_pg
--TPC-DS Q22
-- start query 1 in stream 0 using template ../query_templates/query22.tpl
select i_product_name
,i_brand
,i_class
,i_category
,avg(inv_quantity_on_hand) qoh
from plato.inventory
,plato.date_dim
,plato.item
where inv_date_sk=d_date_sk
and inv_item_sk=i_item_sk
and d_month_seq between 1212 and 1212 + 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 ../query_templates/query22.tpl
|
