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

     1  use tpch;
     2  select
     3  o_orderpriority,
     4  count(*) as order_count
     5  from
     6  orders
     7  where
     8  o_orderdate >= date '1997-07-01'
     9  and o_orderdate < date '1997-07-01' + interval '3' month
    10  and exists (
    11  select
    12  *
    13  from
    14  lineitem
    15  where
    16  l_orderkey = o_orderkey
    17  and l_commitdate < l_receiptdate
    18  )
    19  group by
    20  o_orderpriority
    21  order by
    22  o_orderpriority
    23  ;
    24  o_orderpriority	order_count
    25  1-URGENT	16
    26  2-HIGH	9
    27  3-MEDIUM	6
    28  4-NOT SPECIFIED	8
    29  5-LOW	6