sql.presto.tpcds.q28.sql Maven / Gradle / Ivy
SELECT *
FROM
(
SELECT
"avg"("ss_list_price") "b1_lp"
, "count"("ss_list_price") "b1_cnt"
, "count"(DISTINCT "ss_list_price") "b1_cntd"
FROM
${database}.${schema}.store_sales
WHERE ("ss_quantity" BETWEEN 0 AND 5)
AND (("ss_list_price" BETWEEN 8 AND (8 + 10))
OR ("ss_coupon_amt" BETWEEN 459 AND (459 + 1000))
OR ("ss_wholesale_cost" BETWEEN 57 AND (57 + 20)))
) b1
, (
SELECT
"avg"("ss_list_price") "b2_lp"
, "count"("ss_list_price") "b2_cnt"
, "count"(DISTINCT "ss_list_price") "b2_cntd"
FROM
${database}.${schema}.store_sales
WHERE ("ss_quantity" BETWEEN 6 AND 10)
AND (("ss_list_price" BETWEEN 90 AND (90 + 10))
OR ("ss_coupon_amt" BETWEEN 2323 AND (2323 + 1000))
OR ("ss_wholesale_cost" BETWEEN 31 AND (31 + 20)))
) b2
, (
SELECT
"avg"("ss_list_price") "b3_lp"
, "count"("ss_list_price") "b3_cnt"
, "count"(DISTINCT "ss_list_price") "b3_cntd"
FROM
${database}.${schema}.store_sales
WHERE ("ss_quantity" BETWEEN 11 AND 15)
AND (("ss_list_price" BETWEEN 142 AND (142 + 10))
OR ("ss_coupon_amt" BETWEEN 12214 AND (12214 + 1000))
OR ("ss_wholesale_cost" BETWEEN 79 AND (79 + 20)))
) b3
, (
SELECT
"avg"("ss_list_price") "b4_lp"
, "count"("ss_list_price") "b4_cnt"
, "count"(DISTINCT "ss_list_price") "b4_cntd"
FROM
${database}.${schema}.store_sales
WHERE ("ss_quantity" BETWEEN 16 AND 20)
AND (("ss_list_price" BETWEEN 135 AND (135 + 10))
OR ("ss_coupon_amt" BETWEEN 6071 AND (6071 + 1000))
OR ("ss_wholesale_cost" BETWEEN 38 AND (38 + 20)))
) b4
, (
SELECT
"avg"("ss_list_price") "b5_lp"
, "count"("ss_list_price") "b5_cnt"
, "count"(DISTINCT "ss_list_price") "b5_cntd"
FROM
${database}.${schema}.store_sales
WHERE ("ss_quantity" BETWEEN 21 AND 25)
AND (("ss_list_price" BETWEEN 122 AND (122 + 10))
OR ("ss_coupon_amt" BETWEEN 836 AND (836 + 1000))
OR ("ss_wholesale_cost" BETWEEN 17 AND (17 + 20)))
) b5
, (
SELECT
"avg"("ss_list_price") "b6_lp"
, "count"("ss_list_price") "b6_cnt"
, "count"(DISTINCT "ss_list_price") "b6_cntd"
FROM
${database}.${schema}.store_sales
WHERE ("ss_quantity" BETWEEN 26 AND 30)
AND (("ss_list_price" BETWEEN 154 AND (154 + 10))
OR ("ss_coupon_amt" BETWEEN 7326 AND (7326 + 1000))
OR ("ss_wholesale_cost" BETWEEN 7 AND (7 + 20)))
) b6
LIMIT 100