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