Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. Get to know the tables - supporter
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 information from the supporter table.

People who have donated some money at least once have an account automatically created. From that moment on, they are called supporters. Each supporter has an id, a first_name and last_name. Once you're a supporter, you can donate more money under the same account or start your own project.