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