SELECT INFWHSE.IW_GEOGRAPHY_DIMENSIONS.FBA_NAME, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.DMA_CODE, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.DMA_NAME, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.CUST_ID, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.CUST_NAME, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.CITY, decode(INFWHSE.IW_PRODUCT_DIMENSIONS.SALES_BRAND_DESC,'COORS BRAND','COORS ORIGINAL','GEORGE KILLIAN','KILLIAN''S',INFWHSE.IW_PRODUCT_DIMENSIONS.SALES_BRAND_DESC), INFWHSE.IW_PRODUCT_DIMENSIONS.NON_BRAND_PACKAGE_DESC, decode(substr(INFWHSE.IW_PRODUCT_DIMENSIONS.CONTAINER_TYPE,1,3),'KEG','DRAFT','PAR','DRAFT','CAN','CAN','BTL', 'BOTTLE','PET','BOTTLE',INFWHSE.IW_PRODUCT_DIMENSIONS.CONTAINER_TYPE), decode(INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY,'Asian','GENERAL MKT','General Market','GENERAL MKT','Hispanic','HISPANIC','African American','AFRICAN AMERICAN','#EMPTY','UNASSIGNED ACCTS',NULL,'UNASSIGNED ACCTS','#N/A','UNASSIGNED ACCTS',INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY), INFWHSE.IW_RETAIL_DIMENSIONS.PREMISE_TYPE, INFWHSE.IW_RETAIL_DIMENSIONS.TRADE_CHNL_DESC, sum(CY_4WK_SLD_VOL_SW_SP_DT_RS. CASE_EQUIV_QTY) FROM INFWHSE.IW_SLD_VOL_SW_SP_DT_RS CY_4WK_SLD_VOL_SW_SP_DT_RS, INFWHSE.IW_PRODUCT_DIMENSIONS, INFWHSE.IW_GEOGRAPHY_DIMENSIONS, INFWHSE.IW_TIME_DIMENSIONS, INFWHSE.IW_RETAIL_DIMENSIONS WHERE ( INFWHSE.IW_PRODUCT_DIMENSIONS.PRODUCT_SELECTION_ID=CY_4WK_SLD_VOL_SW_SP_DT_RS.PRODUCT_SELECTION_ID ) AND ( INFWHSE.IW_RETAIL_DIMENSIONS.RETAIL_SELECTION_ID=CY_4WK_SLD_VOL_SW_SP_DT_RS.RETAIL_SELECTION_ID ) AND ( INFWHSE.IW_GEOGRAPHY_DIMENSIONS.GEOGRAPHY_SELECTION_ID=CY_4WK_SLD_VOL_SW_SP_DT_RS.GEOGRAPHY_SELECTION_ID ) AND ( CY_4WK_SLD_VOL_SW_SP_DT_RS.TIME_SELECTION_ID between INFWHSE.IW_TIME_DIMENSIONS.ROLLING_PERIOD_START_WEEK_SID and INFWHSE.IW_TIME_DIMENSIONS.ROLLING_PERIOD_END_WEEK_SID AND INFWHSE.IW_TIME_DIMENSIONS.CAL_TYPE = 'SALES' AND INFWHSE.IW_TIME_DIMENSIONS.TIME_TYPE = '4 WEEK' ) AND ( INFWHSE.IW_PRODUCT_DIMENSIONS.PRODUCT_TYPE = 'SALES PACKAGE' ) AND ( decode( INFWHSE.IW_TIME_DIMENSIONS.ROLLING_PERIOD_END_YEAR, NULL, INFWHSE.IW_TIME_DIMENSIONS.YEAR, INFWHSE.IW_TIME_DIMENSIONS.ROLLING_PERIOD_END_YEAR) IN (2003) AND DECODE(INFWHSE.IW_TIME_DIMENSIONS.ROLLING_PERIOD_END_WEEK, NULL, INFWHSE.IW_TIME_DIMENSIONS.WEEK_OF_YEAR, INFWHSE.IW_TIME_DIMENSIONS.ROLLING_PERIOD_END_WEEK) BETWEEN 1 AND 43 AND (decode(INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY,'Asian','GENERAL MKT','General Market','GENERAL MKT','Hispanic','HISPANIC','African American','AFRICAN AMERICAN','#EMPTY','UNASSIGNED ACCTS',NULL,'UNASSIGNED ACCTS','#N/A','UNASSIGNED ACCTS',INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY) IN ('GENERAL MKT', 'UNASSIGNED ACCTS') OR decode(INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY,'Asian','GENERAL MKT','General Market','GENERAL MKT','Hispanic','HISPANIC','African American','AFRICAN AMERICAN','#EMPTY','UNASSIGNED ACCTS',NULL,'UNASSIGNED ACCTS','#N/A','UNASSIGNED ACCTS',INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY) IN ('HISPANIC')) ) GROUP BY INFWHSE.IW_GEOGRAPHY_DIMENSIONS.FBA_NAME, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.DMA_CODE, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.DMA_NAME, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.CUST_ID, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.CUST_NAME, INFWHSE.IW_GEOGRAPHY_DIMENSIONS.CITY, decode(INFWHSE.IW_PRODUCT_DIMENSIONS.SALES_BRAND_DESC,'COORS BRAND','COORS ORIGINAL','GEORGE KILLIAN','KILLIAN''S',INFWHSE.IW_PRODUCT_DIMENSIONS.SALES_BRAND_DESC), INFWHSE.IW_PRODUCT_DIMENSIONS.NON_BRAND_PACKAGE_DESC, decode(substr(INFWHSE.IW_PRODUCT_DIMENSIONS.CONTAINER_TYPE,1,3),'KEG','DRAFT','PAR','DRAFT','CAN','CAN','BTL', 'BOTTLE','PET','BOTTLE',INFWHSE.IW_PRODUCT_DIMENSIONS.CONTAINER_TYPE), decode(INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY,'Asian','GENERAL MKT','General Market','GENERAL MKT','Hispanic','HISPANIC','African American','AFRICAN AMERICAN','#EMPTY','UNASSIGNED ACCTS',NULL,'UNASSIGNED ACCTS','#N/A','UNASSIGNED ACCTS',INFWHSE.IW_RETAIL_DIMENSIONS.ETHNICITY), INFWHSE.IW_RETAIL_DIMENSIONS.PREMISE_TYPE, INFWHSE.IW_RETAIL_DIMENSIONS.TRADE_CHNL_DESC