Survey Reporting
We are currently reporting on survey results and noticed that, since questions are not mandatory to answer, the data is slightly skewed with the scores that they are reporting. They may report a score of 100% even though not all 5 questions are answered, which we don't want to count in the equation. Is there a way to write a SQL query (working in MSSQL) that would throw out any surveys that do not have all questions answered (there are 5 total questions)?