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


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


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.