EXPLAIN select o_orderpriority, count(*) as order_count from orders where o_orderdate >= date '1997-11-01' and o_orderdate < date '1997-11-01' + interval '3 months' and exists ( select * from lineitem where l_orderkey = o_orderkey and l_commitdate < l_receiptdate ) group by o_orderpriority order by o_orderpriority;
        plan         
---------------------
        sort        
                    
       groupby      
                    
    leftsemijoin    
    hash            
                    
 tablescan tablescan
 orders    lineitem 
(9 rows)