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
3. Get to know the tables – project
Basic CTE
Summary

Instruction

Fine. Let's get to know the second table.

Exercise

Select all information from the project table.

A project is a creative initiative which asks supporters for money. Each project has:

  • id – identifier of the project,
  • category – category of the project, like traveling, games, etc.,
  • author_id – id of the supporter who created the project
  • minimal_amount – it signifies a concept well known on crowdfunding websites – this is the minimal amount which you think is necessary to complete your project. If you raise more than that – fantastic, your project can be even better. If you do not exceed the minimal amount, however, the fund raising fails and the money goes back to supporters.