github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q10.result (about)

     1  use tpch;
     2  select
     3  c_custkey,
     4  c_name,
     5  sum(l_extendedprice * (1 - l_discount)) as revenue,
     6  c_acctbal,
     7  n_name,
     8  c_address,
     9  c_phone,
    10  c_comment
    11  from
    12  customer,
    13  orders,
    14  lineitem,
    15  nation
    16  where
    17  c_custkey = o_custkey
    18  and l_orderkey = o_orderkey
    19  and o_orderdate >= date '1993-03-01'
    20  and o_orderdate < date '1993-03-01' + interval '3' month
    21  and l_returnflag = 'R'
    22  and c_nationkey = n_nationkey
    23  group by
    24  c_custkey,
    25  c_name,
    26  c_acctbal,
    27  c_phone,
    28  n_name,
    29  c_address,
    30  c_comment
    31  order by
    32  revenue desc
    33  limit 20
    34  ;
    35  c_custkey	c_name	revenue	c_acctbal	n_name	c_address	c_phone	c_comment
    36  70	Customer#000000070	316759.4208	4867.52	RUSSIA	mFowIuhnHjp2GjCiYYavkW kUwOjIaTCQ	32-828-107-2832	fter the special asymptotes. ideas after the unusual frets cajole quickly regular pinto be
    37  109	Customer#000000109	272732.4698	-716.10	MOZAMBIQUE	OOOkYBgCMzgMQXUmkocoLb56rfrdWp2NE2c	26-992-422-8153	es. fluffily final dependencies sleep along the blithely even pinto beans. final deposits haggle furiously furiou
    38  106	Customer#000000106	175284.3983	3288.42	ARGENTINA	xGCOEAUjUNG	11-751-989-4627	lose slyly. ironic accounts along the evenly regular theodolites wake about the special, final gifts. 
    39  2	Customer#000000002	121173.0081	121.65	JORDAN	XSTf4,NCwDVaWNe6tEgvwfmRchLXak	23-768-687-3665	l accounts. blithely ironic theodolites integrate boldly: caref
    40  100	Customer#000000100	113840.4294	9889.89	SAUDI ARABIA	fptUABXcmkC5Wx	30-749-445-4907	was furiously fluffily quiet deposits. silent, pending requests boost against 
    41  58	Customer#000000058	103790.5932	6478.46	JORDAN	g9ap7Dk1Sv9fcXEWjpMYpBZIRUohi T	23-244-493-2508	ideas. ironic ideas affix furiously express, final instructions. regular excuses use quickly e
    42  94	Customer#000000094	100840.0020	5500.11	INDONESIA	IfVNIN9KtkScJ9dUjK3Pg5gY1aFeaXewwf	19-953-499-8833	latelets across the bold, final requests sleep according to the fluffily bold accounts. unusual deposits amon
    43  97	Customer#000000097	99194.2317	2164.48	PERU	OApyejbhJG,0Iw3j rd1M	27-588-919-5638	haggle slyly. bold, special ideas are blithely above the thinly bold theo
    44  101	Customer#000000101	90564.6478	7470.96	BRAZIL	sMmL2rNeHDltovSm Y	12-514-298-3699	 sleep. pending packages detect slyly ironic pack
    45  52	Customer#000000052	85250.3310	5630.28	IRAQ	7 QOqGqqSy9jfV51BC71jcHJSD0	21-186-284-5998	ic platelets use evenly even accounts. stealthy theodolites cajole furiou
    46  142	Customer#000000142	74220.1107	2209.81	INDONESIA	AnJ5lxtLjioClr2khl9pb8NLxG2,	19-407-425-2584	. even, express theodolites upo
    47  59	Customer#000000059	71312.3586	3458.60	ARGENTINA	zLOCP0wh92OtBihgspOGl4	11-355-584-3112	ously final packages haggle blithely after the express deposits. furiou
    48  40	Customer#000000040	69690.6972	1335.30	CANADA	gOnGWAyhSV1ofv	13-652-915-8939	rges impress after the slyly ironic courts. foxes are. blithely 
    49  8	Customer#000000008	67088.8134	6819.74	PERU	I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5	27-147-574-9335	among the slyly regular theodolites kindle blithely courts. carefully even theodolites haggle slyly along the ide
    50  49	Customer#000000049	66789.7960	4573.94	IRAN	cNgAeX7Fqrdf7HQN9EwjUa4nxT,68L FKAxzl	20-908-631-4424	nusual foxes! fluffily pending packages maintain to the regular 
    51  26	Customer#000000026	66653.8296	5182.05	RUSSIA	8ljrc5ZeMl7UciP	32-363-455-4837	c requests use furiously ironic requests. slyly ironic dependencies us
    52  77	Customer#000000077	65603.6040	1738.87	PERU	4tAE5KdMFGD4byHtXF92vx	27-269-357-4674	uffily silent requests. carefully ironic asymptotes among the ironic hockey players are carefully bli
    53  136	Customer#000000136	64024.4532	-842.39	GERMANY	QoLsJ0v5C1IQbh,DS1	17-501-210-4726	ackages sleep ironic, final courts. even requests above the blithely bold requests g
    54  112	Customer#000000112	62915.4416	2953.35	ROMANIA	RcfgG3bO7QeCnfjqJT1	29-233-262-8382	rmanently unusual multipliers. blithely ruthless deposits are furiously along the
    55  80	Customer#000000080	57993.8394	7383.53	ALGERIA	K,vtXp8qYB 	10-267-172-7101	tect among the dependencies. bold accounts engage closely even pinto beans. ca