I have a MS SQL Query on a web page -
SELECT [login to view URL], [login to view URL], QuestionOptions.[option]
FROM SurveyResponse INNER JOIN
QuestionOptions ON [login to view URL] = [login to view URL]
WHERE ([login to view URL] = 11)
SurveyResponse is a table with thousands of users response to questions
QuestionOptions is a table with the available responses to the questions.
I need the query updated so that I get just a count of how many of each option available is in the query - not the full list of all several thousand results. - need to keep the questionid so we only have one question at a time
6 freelancers are bidding on average $22 for this job
Hello, How are you? I am strongest SQL expert. I have experience to develop several websites for 4+ years. If you have any issue, I will solve it quickly. Please reply me. Thank you.