BEGIN;
BEGIN
select
	l_orderkey,
	sum(l_extendedprice * (1 - l_discount)) as revenue,
	o_orderdate,
	o_shippriority
from
	customer,
	orders,
	lineitem
where
	c_mktsegment = 'MACHINERY'
	and c_custkey = o_custkey
	and l_orderkey = o_orderkey
	and o_orderdate < date '1995-03-14'
	and l_shipdate > date '1995-03-14'
group by
	l_orderkey,
	o_orderdate,
	o_shippriority
order by
	revenue desc,
	o_orderdate
LIMIT 10;
 l_orderkey |     revenue      | o_orderdate | o_shippriority 
------------+------------------+-------------+----------------
   45428128 | 447475.774072541 | 1995-02-09  |              0
    4178471 | 435622.839960596 | 1995-02-28  |              0
   54341126 |  433150.25875952 | 1995-03-11  |              0
   20601378 | 432196.809442046 | 1995-03-13  |              0
   54398758 | 430100.012504347 | 1995-03-13  |              0
   12378086 | 428807.007035517 | 1995-03-13  |              0
   34026084 | 427506.410120145 | 1995-03-12  |              0
    4011108 | 426178.098670207 | 1995-03-10  |              0
   41696897 | 424707.532843546 | 1995-03-11  |              0
   51780900 | 424669.225499873 | 1995-03-06  |              0
(10 rows)

COMMIT;
COMMIT