]>
git.proxmox.com Git - ceph.git/blob - ceph/src/s3select/TPCDS/sample-queries-tpcds/query94.sql
909281da0876270a8b3c28120b6f8ee1b6975356
1 -- start query 1 in stream 0 using template query94.tpl and seed 2031708268
3 count(distinct ws_order_number
) as "order count"
4 ,sum(ws_ext_ship_cost
) as "total shipping cost"
5 ,sum(ws_net_profit
) as "total net profit"
12 d_date
between cast('1999-4-01' as date) and
13 (cast('1999-4-01' as date) + interval '60' day)
14 and ws1.ws_ship_date_sk
= d_date_sk
15 and ws1.ws_ship_addr_sk
= ca_address_sk
17 and ws1.ws_web_site_sk
= web_site_sk
18 and web_company_name
= 'pri'
21 where ws1.ws_order_number
= ws2.ws_order_number
22 and ws1.ws_warehouse_sk
<> ws2.ws_warehouse_sk
)
23 and not exists(select *
25 where ws1.ws_order_number
= wr1.wr_order_number
)
26 order by count(distinct ws_order_number
)
29 -- end query 1 in stream 0 using template query94.tpl