• Home
• com.alibaba
• druid
• 1.2.17
• 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.

tpch.q13.sql Maven / Gradle / Ivy

-- database: presto; groups: tpch; tables: customer
SELECT c_count,
       count(*) AS custdist
FROM (SELECT c_custkey,
             count(o_orderkey)
      FROM customer
               LEFT OUTER JOIN orders 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