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
3. The Project table
Basic CTEs
Summary

Instruction

Let's get to know the second table.

Exercise

Select all the information from the Project table.

A project is a creative initiative which requires donations from supporters. Each project has the following fields:

  • Id – the identifier of the project,
  • Category – the category of the project, like traveling, games, etc.,
  • AuthorId – the ID of the supporter who created the project,
  • MinimalAmount – it signifies a concept well known on crowdfunding websites: the minimal amount necessary to complete your project. If you raise more than that – fantastic, your project can be even better. If you do not meet the minimal amount, the fund raising fails and the money goes back to the supporters.