BEGIN;
BEGIN
select
	l_orderkey,
	sum(l_extendedprice * (1 - l_discount)) as revenue,
	o_orderdate,
	o_shippriority
from
	customer,
	orders,
	lineitem
where
	c_mktsegment = 'HOUSEHOLD'
	and c_custkey = o_custkey
	and l_orderkey = o_orderkey
	and o_orderdate < date '1995-03-24'
	and l_shipdate > date '1995-03-24'
group by
	l_orderkey,
	o_orderdate,
	o_shippriority
order by
	revenue desc,
	o_orderdate
LIMIT 10;
 l_orderkey |     revenue      | o_orderdate | o_shippriority 
------------+------------------+-------------+----------------
  356846178 | 515224.104343325 | 1995-03-19  |              0
  501322081 |  496480.35509485 | 1995-02-04  |              0
   37911232 | 477742.994564992 | 1995-03-21  |              0
  191691776 | 472636.197081233 | 1995-03-14  |              0
  493528132 | 468488.903191469 | 1995-02-26  |              0
  174824647 | 466075.319457816 | 1995-01-21  |              0
  217865287 | 465172.778466526 | 1995-03-19  |              0
  103463138 | 465076.597480122 | 1995-03-20  |              0
  271880324 | 464526.734351146 | 1995-03-02  |              0
  353610375 | 462081.875177904 | 1995-02-17  |              0
(10 rows)

COMMIT;
COMMIT