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


Let's get to know the second table.


Select all the information from the Project table.

A project is a creative initiative which requires donations from supporters. Each project has the following fields:

  • Id – the identifier of the project,
  • Category – the category of the project, like traveling, games, etc.,
  • AuthorId – the ID of the supporter who created the project,
  • MinimalAmount – it signifies a concept well known on crowdfunding websites: the minimal amount necessary to complete your project. If you raise more than that – fantastic, your project can be even better. If you do not meet the minimal amount, the fund raising fails and the money goes back to the supporters.