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 '1993-04-01'
	and o_orderdate < cast(date '1993-04-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                                                 
-----------+--------------------+------------------+-----------+---------------------------+-----------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------------
   1192936 | Customer#001192936 |  872757.90660211 |   -234.16 | RUSSIA                    | dbHH,k2N4MhLVKu9XnJUDiNg                | 32-644-511-4374 | lites. special theodolites sleep carefully above th
    266653 | Customer#000266653 | 822911.868782284 |   6519.98 | SAUDI ARABIA              | 5byoHPAaRuoOcnyxz                       | 30-738-348-9334 | its. carefully ironic theodolites are furiously. ironic packages wake slyly bold reque
   1241903 | Customer#001241903 |  747572.65578502 |   2395.84 | SAUDI ARABIA              | 9V0PL2KxqGH83h3euseNZe1nKFp             | 30-836-649-2301 | regular requests use carefully. ironic, ironic ac
   1178050 | Customer#001178050 | 739114.210185633 |   7242.53 | IRAN                      | feoPhqB05ilkywxgo7kCPrJt                | 20-718-819-6353 | ts wake according to the even, pending deposits. regular, pending requests are. bold
    758191 | Customer#000758191 | 727539.969103415 |    227.42 | BRAZIL                    | Bb4YM38ZkrjYK6wR37sc8L02FPntjRw1m6LAm   | 12-290-974-4176 |  packages are fluffily slyly ironic 
    105391 | Customer#000105391 |  724727.11041101 |   8289.84 | BRAZIL                    | ETKGsye2H HaQXCvS8JnYnvqlPX9AvTQYnmKKd  | 12-406-554-1750 | eep quickly against the quickly even ideas. furiously unusual deposits above the quickly pending dinos
    842824 | Customer#000842824 | 721662.694897946 |   4184.68 | ETHIOPIA                  | U921jtWMsPGxMWM                         | 15-394-169-1098 | unts. thin, unusual depths are finally. excuses near the silent instructions are quickly pending requests
    940375 | Customer#000940375 |  716583.22249465 |    6942.3 | IRAN                      | v8,h5rcbqRNNFMjL                        | 20-499-624-6444 | ress slowly final requests. unusual 
   1163617 | Customer#001163617 | 708880.937525644 |   1840.89 | IRAQ                      | 9yr2h99xclG2Bj                          | 21-252-822-9416 | kages. slyly regular requests are furiously even notornis. unusual dependen
    309157 | Customer#000309157 | 707149.138534378 |     678.2 | ARGENTINA                 | HCFmX29qi oOTeu3rTBnZt5Gzo7ZD7ITZfoAspb | 11-423-392-5805 | ic deposits wake boldly. special packages nag quickly along 
    964273 | Customer#000964273 | 697651.385863739 |   6398.29 | BRAZIL                    | qMoJ5jGkGoCRN2p                         | 12-840-421-3520 | s the slyly pending patterns cajole blithely unusual dependencies. final, regular packages try 
   1486345 | Customer#001486345 | 695912.294324915 |    6358.7 | ALGERIA                   | XB36dQFytMbzqW4x 8UenMGUYJ              | 10-435-498-5491 | long the escapades detect carefully ironic ideas. regular, regular requests
    223381 | Customer#000223381 | 695681.734912159 |    611.81 | ALGERIA                   | 2QVK0arT1DD                             | 10-633-303-8581 | s. regular accounts believe slyly express, ruthless deposits. fluffily ironic foxes affix slyly. f
    712528 | Customer#000712528 | 691517.192066244 |   1817.24 | ARGENTINA                 | e4Fv,dPSvihxF                           | 11-948-259-5021 | iously. even packages dazzle above the slow th
   1254760 | Customer#001254760 | 689371.872640131 |   -113.13 | PERU                      | 0FK4kA8WZEp,8rb5fW                      | 27-384-335-4081 | foxes wake quickly after the regular courts. final, express excu
   1300444 | Customer#001300444 | 685642.659447051 |   1329.86 | EGYPT                     | 9CcXvJFUjU15,cpJR                       | 14-557-799-6412 |  quickly pending instructions. blithely express theodolites use alongside of the ca
    331810 | Customer#000331810 | 681828.293235588 |   1479.79 | CANADA                    | 7MbKGIWcWOnag10tncW8HfxHL79s            | 13-939-524-2251 | dolites. fluffily final accounts cajole carefully. final, even packag
    990490 | Customer#000990490 | 679277.214091144 |   9184.69 | GERMANY                   | 65gZqIuDLhgpjmVaIb,RCa,qaRp             | 17-563-940-9939 | y even pinto beans are furiously. final instructions sleep alongside of the fluffily special asym
   1188853 | Customer#001188853 | 677577.339773848 |   4758.06 | INDIA                     | aMZwAt,r3To8PGetM17kEswy                | 18-213-578-4109 | arefully against the final theodolites. ironic dependenci
   1053604 | Customer#001053604 | 671835.505039955 |   9512.78 | ROMANIA                   | WzIf0aoN5uy  L12tOjVgEaIB Mj6v9uUNM3I   | 29-759-834-1754 | blate blithely final foxes. carefully pending ideas haggle slyly. blithely even dependencies are furiou
(20 rows)

COMMIT;
COMMIT