Introduction
Quiz
8. Nested CTEs with a subquery
Summary

Instruction

Nice! How about another nested CTE, this time with a subquery?

Exercise

First, count the number of employees for each project where HoursSpent is greater than or equal to 20. Second, find the average number of such employees for a given client. Finally, show the MaximalAverage alongside the ClientId that the maximal average concerns.