BEGIN;
BEGIN
select
	c_custkey,
	c_name,
	sum(l_extendedprice * (1 - l_discount)) as revenue,
	c_acctbal,
	n_name,
	c_address,
	c_phone,
	c_comment
from
	customer,
	orders,
	lineitem,
	nation
where
	c_custkey = o_custkey
	and l_orderkey = o_orderkey
	and o_orderdate >= date '1994-03-01'
	and o_orderdate < cast(date '1994-03-01' + interval '3 month' as date)
	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;
 c_custkey |       c_name       |     revenue      | c_acctbal |          n_name           |                c_address                 |     c_phone     |                                                      c_comment                                                      
-----------+--------------------+------------------+-----------+---------------------------+------------------------------------------+-----------------+---------------------------------------------------------------------------------------------------------------------
   1390222 | Customer#001390222 | 843353.176951275 |   -172.69 | FRANCE                    | wkr8tZnzZfhTEW                           | 16-679-821-8279 | onic asymptotes breach even courts. slyly express platelets believe fluffily regular packages. even packa
    179122 | Customer#000179122 | 823933.262332347 |       633 | ETHIOPIA                  | ImdwqdO1j0Xk                             | 15-787-260-5708 |  the quickly unusual packages! furiously special packages across the carefully regular deposits are b
    699974 | Customer#000699974 | 808911.904894055 |   2891.89 | SAUDI ARABIA              | HAxn,e1JQVEQ,7Mu3vdGEg7myRZvctwfKyYunf I | 30-865-607-7407 | lites. furiously regular foxes are along the furiously regular pinto bean
    685849 | Customer#000685849 | 773890.483712545 |   -349.36 | JAPAN                     | GHHIMBK4QnLhI                            | 22-908-620-7455 | the unusual dinos wake slyly blithely special deposits. slyly final platelets believe. ironi
    175699 | Customer#000175699 | 751500.119981066 |   3024.05 | ROMANIA                   | zvg,fyV84IAc01qkSzqYUvi0aZ2OUhV5dc       | 29-201-730-1750 | ges use furiously slyly even dependencies. fluffily regular deposits affix around the accounts. blithely final depo
    806566 | Customer#000806566 | 744400.471258678 |   1157.27 | GERMANY                   | bc0lFgLW MSoU7qP5JKfHSRLXcYpp2DofKt6     | 17-762-230-9031 | ckages. express packages nod blithe
   1482700 | Customer#001482700 | 733791.533807575 |   8535.43 | ROMANIA                   | loC24OSzOaE1ehFq9gVfcDkBaMU3Ol,oO5k0GyV, | 29-396-536-3548 | nag. furiously dogged ideas sle
     78145 | Customer#000078145 | 730477.876074204 |   6012.69 | GERMANY                   | GfbA9hNXG1ebLCXj,fsGqHRF7iH5174          | 17-807-752-5695 | against the regular packages. ironic pa
   1171042 | Customer#001171042 | 725999.052059587 |   5621.08 | RUSSIA                    | Jtw5t7gpgh4WhnDYBHzUFcCndJ1GRO8Zft       | 32-707-858-6894 | riously final theodolites integrate quickly even, bold package
   1139227 | Customer#001139227 | 724106.707301108 |   1624.44 | RUSSIA                    | ZwNhNlqIDtjVrII4JEXR 6YKMIV5nDXeVi8,T    | 32-962-252-1986 | ke slyly blithely regular requests. close, regular requests nag furiously iro
     24592 | Customer#000024592 | 719379.449399075 |   -237.48 | ALGERIA                   | VjwO4BC7FMKeJRGkKuBK                     | 10-684-336-5808 | the furiously regular packages.
   1392508 | Customer#001392508 | 718947.908727108 |    7299.6 | KENYA                     | Py 3fixLMNzvMX                           | 24-742-721-5822 |  requests eat furiously alongside of the bold ideas. blithely ironic foxes sleep carefull
    986614 | Customer#000986614 | 713930.537797481 |   -391.36 | ROMANIA                   | fp,aYmHWdhsATRxWqH5kTxgkz,VH0tkG         | 29-174-883-2495 | riously final instructions alongside of the fluffily special foxes boost fluffily according to the regular reques
    267589 | Customer#000267589 |  709745.62189445 |   7962.28 | BRAZIL                    | pBLsa5ZIu6Kp5VHvuDw9OGpAoedWW5qw         | 12-703-470-8926 | ! ironic, ironic dolphins above the packages are around 
    512893 | Customer#000512893 | 708760.140054883 |    931.37 | RUSSIA                    | 0lqXTy 0B0Eq                             | 32-517-580-8327 | ve the carefully regular deposits. quickly daring dolphins according to the fur
   1498981 | Customer#001498981 |    699077.114612 |   1686.82 | ARGENTINA                 | DfGOMYLhxUUle0i                          | 11-220-202-7603 | ironic platelets along the carefully final theodolites sleep carefully after the slyly specia
    421414 | Customer#000421414 | 697292.972805751 |   8002.31 | KENYA                     | WcyqUtcKbCttHmWaxFQ4r                    | 24-551-544-5915 |  foxes. blithely regular packages t
    896674 | Customer#000896674 | 690380.852218674 |   9191.72 | FRANCE                    | hNm2ctwBIZKpirUSPxYHaIYY                 | 16-579-318-4889 | s use against the furiously regular accounts. pending deposits hagg
    617845 | Customer#000617845 | 689794.239688353 |   -679.91 | ARGENTINA                 | D,uIwUtjB8NJa236c,fJXjZqDd1Ax3           | 11-749-861-5782 | ular foxes. quickly ironic dependencies wake pending theodolites. bl
    253957 | Customer#000253957 | 688595.807712635 |   7166.31 | PERU                      | gmIJK5vG6jEVF5,Pvb9FS                    | 27-208-177-8701 | ns sleep blithely unusual packages. slyly close patterns sleep alongside of the fl
(20 rows)

COMMIT;
COMMIT