Calculate Survey Result Percentage using SQL Server

Dear All,

I have a survey application consists of 36 questions with options as

Sample table:

CREATE TABLE [dbo].[survey](
[Emp_Id] [varchar](50) NOT NULL,
[Question1] [int],[Question2] [int],[Question3] [int],[Question4] [int],[Question5] [int] ,[Question6] [int] ,
[Question7] [int] ,[Question8] [int] ,[Question9] [int] ,[Question10] [int], [Question11] [int], [Question12] [int] ,
[Question13] [int], ) ON [PRIMARY]

GO

Result:

I want to display the survey result as options selected by the user’s percentage.

Question 1

Option selected (5) by 80%

Option selected (4) by 90%

Option selected (3) by 70%

Option selected (2) by 60%

Option selected (1) by 10%

Thanks