TPC-H Q4

/* using 19620718 as a seed to the RNG */
SELECT
  o_orderpriority,
  COUNT(*) AS order_count
FROM orders
WHERE
  o_orderdate >= CAST('1996-07-01' AS DATE)
  AND o_orderdate < DATEADD(MONTH, 3, CAST('1996-07-01' AS DATE))
  AND EXISTS(
    SELECT
      *
    FROM lineitem
    WHERE
      l_orderkey = o_orderkey AND l_commitdate < l_receiptdate
  )
GROUP BY
  o_orderpriority
ORDER BY
  o_orderpriority;