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