github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q7.sql (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  ;