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.
This exercise is part of the course
Intermediate SQL Server
Exercise instructions
- Create a new column,
SourceCountry, defined from these cases:- When
Countryis'us'then it takes the value'USA'. - Otherwise it takes the value
'International'.
- When
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT Country,
CASE WHEN ___ = ___ THEN ___
ELSE ___
END AS ___
FROM Incidents