Question: Figure 2.1. ER Source for Northwind. Q9. Report on the top Customer Names and their Total Order Quantity, where Total Order Quantity is greater than


Figure 2.1. ER Source for Northwind. Q9. Report on the top Customer Names and their Total Order Quantity, where Total Order Quantity is greater than 100, order results by Total Order Quantity in Descending order. Hint: Join Order Details, Order and Customers. Sum the Quantity ordered in Quantity Details for all the Orders for every Customer, but only for sum of quantity >100. Figure 2.1. ER Source for Northwind. Q9. Report on the top Customer Names and their Total Order Quantity, where Total Order Quantity is greater than 100, order results by Total Order Quantity in Descending order. Hint: Join Order Details, Order and Customers. Sum the Quantity ordered in Quantity Details for all the Orders for every Customer, but only for sum of quantity >100
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
