tpcds.query92.sql Maven / Gradle / Ivy

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