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

     1  use tpch;
     2  select
     3  	l_orderkey,
     4  	sum(l_extendedprice * (1 - l_discount)) as revenue,
     5  	o_orderdate,
     6  	o_shippriority
     7  from
     8  	customer,
     9  	orders,
    10  	lineitem
    11  where
    12  	c_mktsegment = 'HOUSEHOLD'
    13  	and c_custkey = o_custkey
    14  	and l_orderkey = o_orderkey
    15  	and o_orderdate < date '1995-03-29'
    16  	and l_shipdate > date '1995-03-29'
    17  group by
    18  	l_orderkey,
    19  	o_orderdate,
    20  	o_shippriority
    21  order by
    22  	revenue desc,
    23  	o_orderdate
    24  limit 10
    25  ;