sql.presto.tpch.q04.sql Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of presto-benchto-benchmarks

There is a newer version: 350

SELECT 
  o.orderpriority, 
  count(*) AS order_count 
FROM 
  "${database}"."${schema}"."${prefix}orders" o
WHERE  
  o.orderdate >= DATE '1993-07-01'
  AND o.orderdate < DATE '1993-07-01' + INTERVAL '3' MONTH
  AND EXISTS (
    SELECT 
      * 
    FROM 
      "${database}"."${schema}"."${prefix}lineitem" l
    WHERE 
      l.orderkey = o.orderkey 
      AND l.commitdate < l.receiptdate
  )
GROUP BY 
  o.orderpriority
ORDER BY 
  o.orderpriority
;