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

     1  use tpch;
     2  select
     3  supp_nation,
     4  cust_nation,
     5  l_year,
     6  sum(volume) as revenue
     7  from
     8  (
     9  select
    10  n1.n_name as supp_nation,
    11  n2.n_name as cust_nation,
    12  extract(year from l_shipdate) as l_year,
    13  l_extendedprice * (1 - l_discount) as volume
    14  from
    15  supplier,
    16  lineitem,
    17  orders,
    18  customer,
    19  nation n1,
    20  nation n2
    21  where
    22  s_suppkey = l_suppkey
    23  and o_orderkey = l_orderkey
    24  and c_custkey = o_custkey
    25  and s_nationkey = n1.n_nationkey
    26  and c_nationkey = n2.n_nationkey
    27  and (
    28  (n1.n_name = 'FRANCE' and n2.n_name = 'ARGENTINA')
    29  or (n1.n_name = 'ARGENTINA' and n2.n_name = 'FRANCE')
    30  )
    31  and l_shipdate between date '1995-01-01' and date '1996-12-31'
    32  ) as shipping
    33  group by
    34  supp_nation,
    35  cust_nation,
    36  l_year
    37  order by
    38  supp_nation,
    39  cust_nation,
    40  l_year
    41  ;
    42  supp_nation	cust_nation	l_year	revenue
    43  ARGENTINA	FRANCE	1995	36554.0010
    44  ARGENTINA	FRANCE	1996	64102.9664