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