MS SQL Server——用例语句从3条记录中创建一行

I have a table that has numeric fields for session and question. Each session has questions 1, 2, and 3. 1= "Effort", 2 = "Satisfaction" and 3 = "Knowledge". There are 5 possible answers 'Extremely Satisfied', 'Very Satisfied', 'Somewhat Satisfied', 'Unsatisfied', 'Extremely Unsatisfied.I have a table that has numeric fields for sess