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

     1  use tpch;
     2  select
     3  nation,
     4  o_year,
     5  sum(amount) as sum_profit
     6  from
     7  (
     8  select
     9  n_name as nation,
    10  extract(year from o_orderdate) as o_year,
    11  l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
    12  from
    13  part,
    14  supplier,
    15  lineitem,
    16  partsupp,
    17  orders,
    18  nation
    19  where
    20  s_suppkey = l_suppkey
    21  and ps_suppkey = l_suppkey
    22  and ps_partkey = l_partkey
    23  and p_partkey = l_partkey
    24  and o_orderkey = l_orderkey
    25  and s_nationkey = n_nationkey
    26  and p_name like '%pink%'
    27  ) as profit
    28  group by
    29  nation,
    30  o_year
    31  order by
    32  nation,
    33  o_year desc
    34  ;
    35  nation	o_year	sum_profit
    36  ARGENTINA	1997	6575.4934
    37  ARGENTINA	1996	12913.1476
    38  ARGENTINA	1995	109908.3997
    39  ARGENTINA	1994	39271.1404
    40  ARGENTINA	1993	39770.6973
    41  ARGENTINA	1992	35740.0000
    42  ETHIOPIA	1998	24489.1496
    43  ETHIOPIA	1997	39665.2644
    44  ETHIOPIA	1996	113173.0956
    45  ETHIOPIA	1995	25732.7452
    46  ETHIOPIA	1994	93731.1008
    47  ETHIOPIA	1993	147385.872
    48  ETHIOPIA	1992	66636.9616
    49  IRAN	1998	116681.1813
    50  IRAN	1997	50964.2584
    51  IRAN	1996	185552.5634
    52  IRAN	1995	103479.6512
    53  IRAN	1994	164106.8680
    54  IRAN	1993	100245.6590
    55  IRAN	1992	73757.9540
    56  IRAQ	1998	21292.0377
    57  IRAQ	1997	128533.3496
    58  IRAQ	1996	141170.6272
    59  IRAQ	1995	16607.1624
    60  IRAQ	1994	16515.2008
    61  IRAQ	1993	138752.8297
    62  IRAQ	1992	71365.9886
    63  KENYA	1997	47549.3594
    64  KENYA	1996	1866.6024
    65  KENYA	1995	13480.5734
    66  KENYA	1994	54826.0012
    67  KENYA	1993	111983.0035
    68  KENYA	1992	7651.5866
    69  MOROCCO	1998	225961.3058
    70  MOROCCO	1997	288732.1257
    71  MOROCCO	1996	295243.1019
    72  MOROCCO	1995	255208.9581
    73  MOROCCO	1994	158194.0814
    74  MOROCCO	1993	159196.2528
    75  MOROCCO	1992	256151.4254
    76  PERU	1998	35151.8682
    77  PERU	1997	99779.3198
    78  PERU	1996	53735.2566
    79  PERU	1995	71954.3164
    80  PERU	1994	73084.5552
    81  PERU	1993	95623.4989
    82  PERU	1992	38212.4187
    83  UNITED KINGDOM	1998	176649.9065
    84  UNITED KINGDOM	1997	74705.2598
    85  UNITED KINGDOM	1996	62768.5129
    86  UNITED KINGDOM	1995	93466.7552
    87  UNITED KINGDOM	1994	89094.2599
    88  UNITED KINGDOM	1993	112886.5742
    89  UNITED KINGDOM	1992	142060.9690
    90  UNITED STATES	1997	111352.3559
    91  UNITED STATES	1996	78268.8638
    92  UNITED STATES	1995	251.2274
    93  UNITED STATES	1994	57303.1500
    94  UNITED STATES	1993	70350.5923
    95  UNITED STATES	1992	65369.7612