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
4. Table allocation
Quiz
Summary

Instruction

Perfect. And finally the last table.

Exercise

Select all information from the table allocation.

At the company we're discussing, each employee (employee_id) can work on a single project (project_id) on a given date (work_date) for a given number of hours (hours_spent). For instance, employees can work on project 1 on Monday, project 2 on Tuesday, again project 1 on Wednesday, etc.