title: Divide the totalorderprice in 1st query with totalorders in 2nd query
body: <p>How to divide the totalorderprice in 1st query with totalorders in 2nd query and save the result in new column</p>
  
  <p><strong>1st Query:</strong></p>
  
  <pre><code>SELECT o.OrderID,SUM((od.UnitPrice * od.Quantity) - (od.Discount/100))+ o.Freight AS TotalOrderPrice
  FROM [Order Details] as od join Orders as o on o.OrderID=od.OrderID
  GROUP BY o.OrderID, o.Freight
  </code></pre>
  
  <p><strong>2nd Query:</strong> </p>
  
  <pre><code>SELECT distinct o.employeeid, count(o.OrderID)as totalorders 
  FROM Orders o 
  GROUP BY o.EmployeeID
  </code></pre>