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

     1  use tpch;
     2  select
     3  c_name,
     4  c_custkey,
     5  o_orderkey,
     6  o_orderdate,
     7  o_totalprice,
     8  sum(l_quantity)
     9  from
    10  customer,
    11  orders,
    12  lineitem
    13  where
    14  o_orderkey in (
    15  select
    16  l_orderkey
    17  from
    18  lineitem
    19  group by
    20  l_orderkey having
    21  sum(l_quantity) > 314
    22  )
    23  and c_custkey = o_custkey
    24  and o_orderkey = l_orderkey
    25  group by
    26  c_name,
    27  c_custkey,
    28  o_orderkey,
    29  o_orderdate,
    30  o_totalprice
    31  order by
    32  o_totalprice desc,
    33  o_orderdate
    34  limit 100
    35  ;
    36  c_name	c_custkey	o_orderkey	o_orderdate	o_totalprice	sum(l_quantity)