Howto parse/modify this sql output?

How should I write a query if I want the current example result:

column1      column2
------------------------------------
A                12
B                22
C                303

To be changed to:

column1      columnX
------------------------------------
A                Hot
B                Cold
C                Something

So a query being able to say "if value 12" then a column, not perse Column2 needs to show value "Hot", and if 22 then cold etc..

Is that possible?
Start Free Trial