github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q3.result (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  ;
    26  l_orderkey	revenue	o_orderdate	o_shippriority
    27  643	174011.2942	1995-03-25	0
    28  5444	166691.7175	1995-03-18	0
    29  4642	113368.5066	1995-02-27	0
    30  3749	83734.8686	1995-02-24	0
    31  5955	65943.2992	1995-03-27	0
    32  5765	65713.4436	1994-12-15	0
    33  5636	64688.1780	1995-02-16	0
    34  930	51611.7600	1994-12-17	0
    35  1445	44384.8914	1995-01-10	0
    36  3399	36727.7730	1995-02-28	0