redshiftTableauQueries.11.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of verdictdb-core Show documentation

Platform-independent, interactive-speed data analytics system

There is a newer version: 0.5.8

SELECT "partsupp"."ps_partkey" AS "ps_partkey",
  SUM(("partsupp"."ps_supplycost" * "partsupp"."ps_availqty")) AS "sum_calculation_6140711155912621_ok"
FROM "tpch10g"."partsupp" "partsupp"
  INNER JOIN "tpch10g"."supplier" "supplier" ON ("partsupp"."ps_suppkey" = "supplier"."s_suppkey")
  INNER JOIN "tpch10g"."nation" "nation" ON ("supplier"."s_nationkey" = "nation"."n_nationkey")
WHERE ("nation"."n_name" = 'GERMANY')
GROUP BY 1