List the top 5 products by units sold.

Individual SQL Assignment Using the same tables as the group SQL assignment (order91, orderdetail etc), create SQL in MySQL to answer the following questions: 1. Which customer bought the most units? (OUTPUT: CustomerName, Units) 2. Which 3 customers bought the most, by $ amount? (OUTPUT: CustomerName, $Amount) 3. List the top 5 products by units sold. 4. List the top 5 products by $ amount. BONUS (Extra Credit) List the top 5 products by units from the country with the most orders.

Still stressed from student homework?
Get quality assistance from academic writers!
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 9294730077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code SOLVE