1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. Intermediate SQL Server
Connected

अभ्यास

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.

निर्देश

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'.