It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
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 of hours among all these projects.