resources/tpch/q3.sql

0001 -- using default substitutions
0002
0003 select
0004         l_orderkey,
0005         sum(l_extendedprice * (1 - l_discount)) as revenue,
0006         o_orderdate,
0007         o_shippriority
0008 from
0009         customer,
0010         orders,
0011         lineitem
0012 where
0013         c_mktsegment = 'BUILDING'
0014         and c_custkey = o_custkey
0015         and l_orderkey = o_orderkey
0016         and o_orderdate < date '1995-03-15'
0017         and l_shipdate > date '1995-03-15'
0018 group by
0019         l_orderkey,
0020         o_orderdate,
0021         o_shippriority
0022 order by
0023         revenue desc,
0024         o_orderdate
0025 limit 10