tpcds.query94.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
count(distinct ws_order_number) as order_count
,sum(ws_ext_ship_cost) as total_shipping_cost
,sum(ws_net_profit) as total_net_profit
from
web_sales ws1
,date_dim
,customer_address
,web_site
where
d_date between cast('1999-2-01' as date) and
date_add(cast('1999-2-01' as date), 60 )
and ws1.ws_ship_date_sk = d_date_sk
and ws1.ws_ship_addr_sk = ca_address_sk
and ca_state = 'IL'
and ws1.ws_web_site_sk = web_site_sk
and web_company_name = 'pri'
and exists (select *
from web_sales ws2
where ws1.ws_order_number = ws2.ws_order_number
and ws1.ws_warehouse_sk <> ws2.ws_warehouse_sk)
and not exists(select *
from web_returns wr1
where ws1.ws_order_number = wr1.wr_order_number)
order by count(distinct ws_order_number)
limit 100