This is just one line of code, but it's a quick example of how to format a number as a percentage in SQL.
I'm collecting FORMAT examples on the SQL menu, you might click the 'SQL General' link above and see...
SELECT
FORMAT(1.00,
'##0.0 %'
), FORMAT(.25,
'###.0%'
)