EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS)
-- using default substitutions


select
	o_orderpriority,
	count(*) as order_count
from
	orders
where
	o_orderdate >= date '1993-07-01'and o_orderdate < date(date '1993-07-01' + interval '3month')
	and exists (select * from lineitem where l_orderkey = o_orderkey and l_commitdate < l_receiptdate)
group by
	o_orderpriority
order by
	o_orderpriority;
;
