0001 SELECT
0002 cc_call_center_id Call_Center,
0003 cc_name Call_Center_Name,
0004 cc_manager Manager,
0005 sum(cr_net_loss) Returns_Loss
0006 FROM
0007 call_center, catalog_returns, date_dim, customer, customer_address,
0008 customer_demographics, household_demographics
0009 WHERE
0010 cr_call_center_sk = cc_call_center_sk
0011 AND cr_returned_date_sk = d_date_sk
0012 AND cr_returning_customer_sk = c_customer_sk
0013 AND cd_demo_sk = c_current_cdemo_sk
0014 AND hd_demo_sk = c_current_hdemo_sk
0015 AND ca_address_sk = c_current_addr_sk
0016 AND d_year = 1998
0017 AND d_moy = 11
0018 AND ((cd_marital_status = 'M' AND cd_education_status = 'Unknown')
0019 OR (cd_marital_status = 'W' AND cd_education_status = 'Advanced Degree'))
0020 AND hd_buy_potential LIKE 'Unknown%'
0021 AND ca_gmt_offset = -7
0022 GROUP BY cc_call_center_id, cc_name, cc_manager, cd_marital_status, cd_education_status
0023 ORDER BY sum(cr_net_loss) DESC
