Introduction
Basic CTEs
10. Multiple CTEs – practice 1
Summary

Instruction

Fine work! It's time to practice!

Exercise

Show the following two groups of supporters:

  • those who donated more than $200 altogether,
  • those who donated at least twice.

For each user, show their Id, FirstName, and LastName.

Stuck? Here's a hint!

Use one CTE for those that donated over 200 dollars and another one for those who donated at least twice. Remember to start with the keyword WITH.

In order to show all the results, even when a person is a member of both groups, use UNION ALL.