tpcds.query32.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(cs_ext_discount_amt) as excess_discount_amount
from catalog_sales
   , item
   , date_dim
where i_manufact_id = 977
  and i_item_sk = cs_item_sk
  and d_date between '2000-01-27' and
    date_add(cast('2000-01-27' as date), 90)
  and d_date_sk = cs_sold_date_sk
  and cs_ext_discount_amt
    > (select 1.3 * avg(cs_ext_discount_amt)
       from catalog_sales
          , date_dim
       where cs_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 = cs_sold_date_sk)
    limit 100