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
3. Project table
Basic CTE
Summary

Instruction

Great! Let's get to know the second table.

Exercise

Select all the information from the project table.

A project is a creative initiative that requires donations from supporters. Each project has a/an:

  • id – A unique identifier for the project.
  • category – The project's category, like traveling, games, etc.
  • author_id – The ID of the person who created the project.
  • minimal_amount – The least amount of money required to complete the project. This is a well-known crowdfunding concept. If you raise more than that amount – fantastic, your project can be even better. If you do not meet the minimal amount, the fundraising fails and donations go back to the relevant supporters.