Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries

Introduction
Quiz
7. Nested CTE
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.