Introduction
Quiz
7. Nested CTEs
Summary

Instruction

That's it! The next question is about nested CTEs.

Exercise

First, find the sum of hours spent by each employee on each project. Then, find the maximum number of hours spent by a single employee on each project. Finally, find the average maximal number of hours from all these projects. Name the column AvgHours.