tpcds.query32.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(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