Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
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.