8. (2pts as bonus) consider a retail table where each row contains the following attributes: datelD, customerID, storeID, City-of-store, productID, Category-of-product, and sale. One record example is like 1/1/2014, C10001, S25, New York, P157, food, $100. For the query task, calculate the total sale value for each product and at each store from New York. A group-by SQL query is: Select productID, storelD, sum(sale) from retail where City-of-store=New York' group by productID, storelD. Now assume we have the text raw file extracted from the above table and would use the map-reduce framework to implement the above query task. Please show the pseudo code of the map function and reduce function. 8. (2pts as bonus) consider a retail table where each row contains the following attributes: datelD, customerID, storeID, City-of-store, productID, Category-of-product, and sale. One record example is like 1/1/2014, C10001, S25, New York, P157, food, $100. For the query task, calculate the total sale value for each product and at each store from New York. A group-by SQL query is: Select productID, storelD, sum(sale) from retail where City-of-store=New York' group by productID, storelD. Now assume we have the text raw file extracted from the above table and would use the map-reduce framework to implement the above query task. Please show the pseudo code of the map function and reduce function