text: -- $ID$
  -- TPC-H/TPC-R Order Priority Checking Query (Q4)
  -- Functional Query Definition
  -- Approved February 1998
  
  
  select
  	o_orderpriority,
  	count(*) as order_count
  from
  	orders
  where
  	o_orderdate >= date '1996-05-01'
  	and o_orderdate < date '1996-05-01' + interval '3' month
  	and exists (
  		select
  			*
  		from
  			lineitem
  		where
  			l_orderkey = o_orderkey
  			and l_commitdate < l_receiptdate
  	)
  group by
  	o_orderpriority
  order by
  	o_orderpriority
  LIMIT 1;
  -- using 1459869488 as a seed to the RNG
  
  
  select
  	o_orderpriority,
  	count(*) as order_count
  from
  	orders
  where
  	o_orderdate >= date '1993-08-01'
  	and o_orderdate < date '1993-08-01' + interval '3' month
  	and exists (
  		select
  			*
  		from
  			lineitem
  		where
  			l_orderkey = o_orderkey
  			and l_commitdate < l_receiptdate
  	)
  group by
  	o_orderpriority
  order by
  	o_orderpriority
  LIMIT 1;
  