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. Is there a way to write a MSSQL query that would throw out any surveys that do not have all questions answered (there are 5 total questions)?