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


In this part, we're going to deal with a crowdfunding website similar to Kickstarter. Let's get to know the first table.


Select all the information from the supporter table.

On our crowdfunding site, people who have donated money at least once automatically have an account created. From that moment on, they are called supporters. Each supporter has an id, a first_name and a last_name. Once someone is a supporter, they can donate more money under the same account or start their own project.