sql.presto.tpcds.q91.sql Maven / Gradle / Ivy
SELECT
"cc_call_center_id" "Call_Center"
, "cc_name" "Call_Center_Name"
, "cc_manager" "Manager"
, "sum"("cr_net_loss") "Returns_Loss"
FROM
${database}.${schema}.call_center
, ${database}.${schema}.catalog_returns
, ${database}.${schema}.date_dim
, ${database}.${schema}.customer
, ${database}.${schema}.customer_address
, ${database}.${schema}.customer_demographics
, ${database}.${schema}.household_demographics
WHERE ("cr_call_center_sk" = "cc_call_center_sk")
AND ("cr_returned_date_sk" = "d_date_sk")
AND ("cr_returning_customer_sk" = "c_customer_sk")
AND ("cd_demo_sk" = "c_current_cdemo_sk")
AND ("hd_demo_sk" = "c_current_hdemo_sk")
AND ("ca_address_sk" = "c_current_addr_sk")
AND ("d_year" = 1998)
AND ("d_moy" = 11)
AND ((("cd_marital_status" = 'M')
AND ("cd_education_status" = 'Unknown'))
OR (("cd_marital_status" = 'W')
AND ("cd_education_status" = 'Advanced Degree')))
AND ("hd_buy_potential" LIKE 'Unknown')
AND ("ca_gmt_offset" = -7)
GROUP BY "cc_call_center_id", "cc_name", "cc_manager", "cd_marital_status", "cd_education_status"
ORDER BY "sum"("cr_net_loss") DESC