• Home
• org.verdictdb
• verdictdb-core
• 0.5.4
• source code
• 1.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.

redshiftTableauQueries.1.sql Maven / Gradle / Ivy

SELECT "lineitem"."l_linestatus" AS "l_linestatus",
  "lineitem"."l_returnflag" AS "l_returnflag",
  AVG(CAST("lineitem"."l_discount" AS DOUBLE PRECISION)) AS "avg_l_discount_ok",
  AVG(CAST("lineitem"."l_extendedprice" AS DOUBLE PRECISION)) AS "avg_l_extendedprice_ok",
  AVG(CAST("lineitem"."l_quantity" AS DOUBLE PRECISION)) AS "avg_l_quantity_ok",
  SUM((("lineitem"."l_extendedprice" * (1 - "lineitem"."l_discount")) * (1 + "lineitem"."l_tax"))) AS "sum_calculation_4310711085325373_ok",
  SUM(("lineitem"."l_extendedprice" * (1 - "lineitem"."l_discount"))) AS "sum_calculation_7060711085256495_ok",
  SUM(1) AS "sum_number_of_records_ok",
  SUM("lineitem"."l_extendedprice") AS "sum_l_extendedprice_ok",
  SUM("lineitem"."l_quantity") AS "sum_l_quantity_ok"
FROM "tpch10g"."lineitem" "lineitem"
WHERE ("lineitem"."l_shipdate" <= DATEADD(DAY,(-90),CAST((DATE '1998-12-01') AS TIMESTAMP WITHOUT TIME ZONE)))
GROUP BY 1,
  2