Simple survey report
This query will provide a quick numeric snapshot of your survey results by question. So, if you have 4 satisfaction levels you will receive back a number from 1-4, with 4 being a perfect score.
SELECT sqdt.QUESTION "Survey Question",round(avg(sadt.RATING),2) "Average Rating" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID INNER JOIN SurveyQuestions sqdt ON sdt.SURQUESID=sqdt.SURQUESID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID GROUP BY sqdt.QUESTION