Exercise

Using CASE statements

In this exercise, you will use a CASE statement to create a new column which specifies whether the Country is USA or International.

Instructions

100 XP

Create a new column, SourceCountry, defined from these cases:
- When Country is 'us' then it takes the value 'USA'.
- Otherwise it takes the value 'International'.