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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in PostgreSQL

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.