blob: 40718918ee65cfc7210010b9f5a636b9b730cdfa (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
--!syntax_pg
--ignore runonopt plan diff
--TPC-H Q4
select
o_orderpriority,
count(*) as order_count
from
plato."orders"
where
o_orderdate >= date '1993-07-01'
and o_orderdate < date '1993-07-01' + interval '3' month
and exists (
select
*
from
plato."lineitem"
where
l_orderkey = o_orderkey
and l_commitdate < l_receiptdate
)
group by
o_orderpriority
order by
o_orderpriority;
|
