db-cust-country.csv : https://docs.google.com/spreadsheets/d/1yZmq-Kf4qokgcGJ7OBF46C3pGP9fMMaQHaIzar2KWTQ/edit?usp=sharing

db-cust-orders.csv : https://docs.google.com/spreadsheets/d/1R3ZbX_SjanHi7rZtBoa-MuSuFN9qPGGwmERl_2fIYKk/edit?usp=sharing

db_order_ref : https://docs.google.com/spreadsheets/d/14jZczTVvq55XSPisznLJvTVIhUuUfecsu0UMrF-pyoc/edit?usp=sharing

db_ref_price.csv : https://docs.google.com/spreadsheets/d/1Xm9tS939d3fMPGvZwXLrj7CF0LFepYlLJ_ItRKAzBTM/edit?usp=sharing

A large company would like to have a brief analysis regarding the sales of its new division, Great Products Inc., that manufactures and sells electronic components. The company has extracted from its main databases the sales records for Great Product Inc. and has sent you the following files: db_cust_country.csv: The global list of their customers' unique identification number (not only customers of Great Products) and their country of origin. db_cust_orders.csv: Sales orders fulfilled by Great Products Inc. that shows the order ID and the customer's ID. db-order.ref.csv: The information that links a sales order ID with the reference ID of the item sold as well as the quantity shipped. db.ref.price.csv: The unit price, in dollars, of an item given its reference ID. a) Merge the information from all four files such that you end up with a table that contains only the customers from Great Products Inc, their customer ID, the ID of the order (the transaction), the country of origin of the customer, the reference ID of the item they purchased, the quantity purchased, and the unit price of that item. b) Display a breakdown by countries of the total revenues generated by Great Product Inc. c) What are the five most popular items sold by Great Products Inc? The five least popular? Give your answer with the reference ID of the items as well as the total quantities sold. A large company would like to have a brief analysis regarding the sales of its new division, Great Products Inc., that manufactures and sells electronic components. The company has extracted from its main databases the sales records for Great Product Inc. and has sent you the following files: db_cust_country.csv: The global list of their customers' unique identification number (not only customers of Great Products) and their country of origin. db_cust_orders.csv: Sales orders fulfilled by Great Products Inc. that shows the order ID and the customer's ID. db-order.ref.csv: The information that links a sales order ID with the reference ID of the item sold as well as the quantity shipped. db.ref.price.csv: The unit price, in dollars, of an item given its reference ID. a) Merge the information from all four files such that you end up with a table that contains only the customers from Great Products Inc, their customer ID, the ID of the order (the transaction), the country of origin of the customer, the reference ID of the item they purchased, the quantity purchased, and the unit price of that item. b) Display a breakdown by countries of the total revenues generated by Great Product Inc. c) What are the five most popular items sold by Great Products Inc? The five least popular? Give your answer with the reference ID of the items as well as the total quantities sold