1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate SQL Server

Exercise

Creating several groups with CASE

In this exercise, you will write a CASE statement to group the values in the DurationSeconds into 5 groups based on the following ranges:

DurationSeconds SecondGroup
<= 120 1
> 120 and <= 600 2
> 600 and <= 1200 3
> 1201 and <= 5000 4
For all other values 5

Instructions

100 XP

Create a new column, SecondGroup, that uses the values in the DurationSeconds column based on the ranges mentioned above.