How to create category based on 1 column

Hi all, I am new to SQL and I am finding a way to categorise 1 column in my table.   Currently I have 1 column called ID and I want to add 1 column that determine the category of that ID. My desir...