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

     1  use tpch;
     2  select
     3  n_name,
     4  sum(l_extendedprice * (1 - l_discount)) as revenue
     5  from
     6  customer,
     7  orders,
     8  lineitem,
     9  supplier,
    10  nation,
    11  region
    12  where
    13  c_custkey = o_custkey
    14  and l_orderkey = o_orderkey
    15  and l_suppkey = s_suppkey
    16  and c_nationkey = s_nationkey
    17  and s_nationkey = n_nationkey
    18  and n_regionkey = r_regionkey
    19  and r_name = 'AMERICA'
    20  and o_orderdate >= date '1994-01-01'
    21  and o_orderdate < date '1994-01-01' + interval '1' year
    22  group by
    23  n_name
    24  order by
    25  revenue desc
    26  ;
    27  n_name	revenue
    28  PERU	272671.5220