• Home
• io.prestosql
• presto-benchto-benchmarks
• 308
• source code
• q13.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.presto.tpch.q13.sql Maven / Gradle / Ivy

SELECT 
  c_count, 
  count(*) as custdist
FROM (
  SELECT 
    c.custkey, 
    count(o.orderkey)
  FROM 
    "${database}"."${schema}"."${prefix}customer" c
    LEFT OUTER JOIN
    "${database}"."${schema}"."${prefix}orders" o
  ON 
    c.custkey = o.custkey
    AND o.comment NOT LIKE '%special%requests%'
  GROUP BY c.custkey
) AS c_orders (c_custkey, c_count)
GROUP BY 
  c_count
ORDER BY 
  custdist DESC, 
  c_count DESC
;