Survey Database Structure
You can use UNPIVOT to transpose the question columns from SurveyResults into rows and then average the KRA values from there. This db&lt;>fiddle shows an example. 

The first query shows the UNPIVOT and the second query shows a dynamically generated SELECT statement that would allow you to add additional question columns without needing to recode the SELECT statement.