I have this table `Shoe`:

```
Shoe size
---------
32
32
36
38
34
40
32

```

And I would like it to display Small for sizes 32-34, medium for 36 and big for 38 and above.

How should I change it using SQL?

I've done

```
ALTER TABLE Shoe 
  ADD Size varchar(50)

```

but I'm not sure how to do a `if shoe size >= 32 and <= 34, size = small` kind of command.

Is the only way to do it is to add them manually?