(select e.lastName as Name, count(o.orderid) as numOrd from Employees e join Orders o on e.employeeid=o.employeeid group by e.lastName)
Buchanan 42 Callahan 104 Davolio 123 Dodsworth 43
let queryResult = (select e.lastName as Name, count(o.orderid) as numOrd from Employees e join Orders o on e.employeeid=o.employeeid group by e.lastName)
select AVG(qr.numOrd) from queryResult qr
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)