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