• Home
• com.alibaba
• druid
• 1.2.20
• source code
• query22.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

tpcds.query22.sql Maven / Gradle / Ivy

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