If I have a column with three different inputed variables, can I use sql to give me a percentage for that column.Here is an example.

column
__________

red
red
red
blue
blue
orange

sql output >

column column(percentage)
________ _________________

red 50%
blue 30%
orange 20%



Thanks for any help!
Trev