redshiftTableauQueries.18.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 "customer"."c_custkey" AS "c_custkey",
  "customer"."c_name" AS "c_name",
  "orders"."o_orderdate" AS "o_orderdate",
  "orders"."o_orderkey" AS "o_orderkey",
  "orders"."o_totalprice" AS "o_totalprice",
  SUM("lineitem"."l_quantity") AS "sum_l_quantity_ok"
FROM "tpch10g"."lineitem" "lineitem"
  INNER JOIN "tpch10g"."orders" "orders" ON ("lineitem"."l_orderkey" = "orders"."o_orderkey")
  INNER JOIN "tpch10g"."customer" "customer" ON ("orders"."o_custkey" = "customer"."c_custkey")
GROUP BY 1,
  2,
  3,
  4,
  5
HAVING (SUM("lineitem"."l_quantity") >= 300.99999999999699)