flink-end-to-end-tests/test-scripts/test-data/tpch/modified-query/q11.sql

-- database: presto; groups: tpch; tables: partsupp,supplier,nation
SELECT
  ps_partkey,
--  sum(ps_supplycost * ps_availqty) AS value
  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
  `value` DESC