• Home
• io.trino
• trino-benchmark-queries
• 468
• source code
• q04.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

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
;