tpcds.query92.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of fastsql Show documentation
Show all versions of fastsql 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