redshiftTableauQueries.19.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 SUM(("lineitem"."l_extendedprice" * (1 - "lineitem"."l_discount"))) AS "sum_calculation_7060711085256495_ok"
FROM "tpch10g"."lineitem" "lineitem"
  INNER JOIN "tpch10g"."part" "part" ON ("lineitem"."l_partkey" = "part"."p_partkey")
WHERE (((((((((((("part"."p_container" = 'SM CASE') OR ("part"."p_container" = 'SM BOX')) OR ("part"."p_container" = 'SM PACK')) OR ("part"."p_container" = 'SM PKG')) AND ("part"."p_brand" = 'Brand#12')) AND ("lineitem"."l_quantity" >= 1)) AND ("lineitem"."l_quantity" <= 11)) AND ("part"."p_size" >= 1)) AND ("part"."p_size" <= 5)) OR ((((((((("part"."p_container" = 'MED BAG') OR ("part"."p_container" = 'MED BOX')) OR ("part"."p_container" = 'MED PACK')) OR ("part"."p_container" = 'MED PKG')) AND ("part"."p_brand" = 'Brand#23')) AND ("lineitem"."l_quantity" >= 10)) AND ("lineitem"."l_quantity" <= 20)) AND ("part"."p_size" >= 1)) AND ("part"."p_size" <= 10))) OR ((((((((("part"."p_container" = 'LG CASE') OR ("part"."p_container" = 'LG BOX')) OR ("part"."p_container" = 'LG PACK')) OR ("part"."p_container" = 'LG PKG')) AND ("part"."p_brand" = 'Brand#34')) AND ("lineitem"."l_quantity" >= 20)) AND ("lineitem"."l_quantity" <= 30)) AND ("part"."p_size" >= 1)) AND ("part"."p_size" <= 15))) AND ("lineitem"."l_shipinstruct" = 'DELIVER IN PERSON') AND ("lineitem"."l_shipmode" = 'AIR'))
HAVING (COUNT(1) > 0)