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
29
30
31
32
33
34
35
36
|
--!syntax_pg
--TPC-H Q10
select
c_custkey,
c_name,
sum(l_extendedprice * (1::numeric - l_discount)) as revenue,
c_acctbal,
n_name,
c_address,
c_phone,
c_comment
from
plato."customer",
plato."orders",
plato."lineitem",
plato."nation"
where
c_custkey = o_custkey
and l_orderkey = o_orderkey
and o_orderdate >= date '1993-10-01'
and o_orderdate < date '1993-10-01' + interval '3' month
and l_returnflag = 'R'
and c_nationkey = n_nationkey
group by
c_custkey,
c_name,
c_acctbal,
c_phone,
n_name,
c_address,
c_comment
order by
revenue desc
limit 20;
|
