How to Create a Case Statement to Classify / Segment Data

Can someone show me how to create a case statement that will classify the sample data below to appear as follows:   At the moment the table in SQL looks like the following:     Sampl...