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

Instruction

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

Exercise

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.