Hey here is a ready juice for you just copy and paste to check.
Happy coding :)
select Final.[Values] as Name,Final.[Value]
from
(
select amber,green,red
from TestPivot
) as pvt
unpivot (
[Value] FOR [Values] IN (amber,green,red)
) as Final
Output will be:
Name |Value
-----------------
amber | 11
green | 89
red | 0