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 MS SQL Server

Introduction
2. The Supporter table
Basic CTEs
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.

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 FirstName, and a LastName. Once you're a supporter, you can donate more money under the same account or start your own project.