blob: 089c838380718dfc2d32a660772faf52472bd154 (
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
27
28
|
--!syntax_pg
--TPC-H Q5
select
n_name,
sum(l_extendedprice * (1::numeric - l_discount)) as revenue
from
plato."customer",
plato."orders",
plato."lineitem",
plato."supplier",
plato."nation",
plato."region"
where
c_custkey = o_custkey
and l_orderkey = o_orderkey
and l_suppkey = s_suppkey
and c_nationkey = s_nationkey
and s_nationkey = n_nationkey
and n_regionkey = r_regionkey
and r_name = 'ASIA'
and o_orderdate >= date '1994-01-01'
and o_orderdate < date '1994-01-01' + interval '1' year
group by
n_name
order by
revenue desc;
|
