tpch.q13.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of druid Show documentation

An JDBC datasource implementation.

There is a newer version: 1.2.23

-- 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