Advanced PROC SOL Features update Accessibility Mode Creating a Macro Variable from an SQL Query a. Produce a report of Country and a new column named Purchases (SUM (Total_Retail_Price)). Group the report by Country. Include only orders placed in 2011. Order the report so that the highest values of Purchases sums are at the top. The data is in the following tables (columns of interest in parenthesis): . Order fact (Customer_ID, Total_Retail_Price) e Customer (Customer_ID, Country) Name the report 2011 Purchases by Country. Label the columns as indicated in the sample report: PROC SQL Output 2811 Purchases by Country Customer Country Purchases uS CA AU $10,655.97 $5,210.5 $3,982.49 Copyright C 2014, SAS Institute Inc., Cary, North Carolina, USA, ALL RIGHTS RESERVED