/*Using AdventureWorks2008R2, write a query to retrieve the customers and their order info. Return the customer id, a customer's total order count, the highest total product quantity contained in an order for all orders of a customer, and a customer's top 3 order For the highest total product quantity contained in an order for all orders of a customer, an example is:Smith has 4 orders. Simon's order #1 has a total sold quantity of 25Simon's order #2 has a total sold quantity of 30Simon's order #3 has a total sold quantity of 28Simon's order #4 has a total sold quantity of 40Then the highest total product quantity contained in an order for all orders of Simon is 40.Keep in mind, it's the total sold product quantity of an order. For example, an order has two products:Product 1 has a quantity of 7Product 2 has a quantity of 12Then the total sold quantity of this order is 19.The top 3 orders have the 3 highest order values. Use TotalDue as the order value. If there is a tie, the tie must be retrieved. The returned data should have the format displayed below. Exclude customers who have had any order with a TotalDuevalue less than $80000.Sort the returned data by CustomerID.*//*29594424249888, 46666, 4771829624410644518, 43875, 4605629641448351131, 55282, 6730529861411543884, 44530, 4606729923425157150, 69531, 6328429995434651761, 69454, 57012*