tpcds.query22.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of druid Show documentation

An JDBC datasource implementation.

There is a newer version: 1.2.23

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 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