Look at the following table (Sale_table), and then answer the question below: a. Roll up the table above using Location dimension, Country instead of City. (3 mark) b. Based on the previous roll up, aggregate the table above using the following queries: (show the result) (2 mark) Select Location_Country, Product_line, sum (Number_Of_UnitesSold)From Sale _table Group by Location_Country, Product_line; Select Product_line, MAX (Number_Of_UnitesSold)From Sale_table_Group by Product_line