• Home
• com.alibaba
• druid
• 1.2.17
• source code
• query92.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.query92.sql Maven / Gradle / Ivy

select sum(ws_ext_discount_amt) as Excess_Discount_Amount
from web_sales
   , item
   , date_dim
where i_manufact_id = 350
  and i_item_sk = ws_item_sk
  and d_date between '2000-01-27' and
    date_add(cast('2000-01-27' as date), 90)
  and d_date_sk = ws_sold_date_sk
  and ws_ext_discount_amt
    > (SELECT 1.3 * avg(ws_ext_discount_amt)
       FROM web_sales
          , date_dim
       WHERE ws_item_sk = i_item_sk
         and d_date between '2000-01-27' and
           date_add(cast('2000-01-27' as date), 90)
         and d_date_sk = ws_sold_date_sk)
order by sum(ws_ext_discount_amt) limit 100