$10.$ CalculationWrite a query to generate the following output with the calculated values filled in$.$Average order amount is the average amount during salesman. While calculating the average order amount, you should exclude the orders that without a salesman.Hint: Using a WITH clause will simplify your code.