Add Literal Percent Sign (%) to my calculation

Question

I want to add a % sign to the derived values from the example below, is it possible? Do I have to somehow use CAST(n)?

ROUND(qy.TotalUnits/qy.TotalCalls *100) AS "Total Conv" +'%'

Answer 1

You should use CONCAT in MySQL to concatenate % with the values received from ROUND(<...>):

CONCAT(ROUND(qy.TotalUnits/qy.TotalCalls *100),'%')

At first, in MySQL + is used for arithmetic operations, secondly, you are trying to concatenate % with the alias, not values.