tpcds.query92.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
Show all versions of druid Show documentation
An JDBC datasource implementation.
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