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 in PostgreSQL

Introduction
2. Project table
Quiz
Summary

Instruction

Good. Before we start, let's discuss the tables we're going to work with. They are used by a company to track their projects and the time employees spend on each project.

Exercise

Select all information from the table project.

The table is quite simple: each project has an id, a client_id and a name.