github.com/matrixorigin/matrixone@v1.2.0/pkg/sql/plan/tpch/q3.sql (about)

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