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
