• Home
• com.alibaba
• druid
• 1.2.17
• source code
• q11.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.q11.sql Maven / Gradle / Ivy

SELECT ps_partkey,
       sum(ps_supplycost * ps_availqty) AS value
FROM
    partsupp,
    supplier,
    nation
WHERE
    ps_suppkey = s_suppkey
  AND s_nationkey = n_nationkey
  AND n_name = 'GERMANY'
GROUP BY
    ps_partkey
HAVING
    sum (ps_supplycost * ps_availqty)
     > (
    SELECT sum (ps_supplycost * ps_availqty) * 0.0001
    FROM
    partsupp
     , supplier
     , nation
    WHERE
    ps_suppkey = s_suppkey
   AND s_nationkey = n_nationkey
   AND n_name = 'GERMANY'
    )
ORDER BY
    value DESC