Questions with multiple answers in 2022, pre-ChatGPT

0

Please login or register to vote for this query.

(click on this box to dismiss)

IT Security Meta

Q&A about the site for information security professionals

SELECT Top 500
  SUM(CASE WHEN AnswerCount > 1 THEN 1 ELSE 0 END) as [Qs w/ Multiple As],
  SUM(CASE WHEN AnswerCount > 0 THEN 1 ELSE 0 END) as [Total Answered Qs],
  COUNT(*) as [Total Qs],
  100.0 * SUM(CASE WHEN AnswerCount > 1 THEN 1 ELSE 0 END) / SUM(CASE WHEN AnswerCount > 0 THEN 1 ELSE 0 END) as [% of Answ'd w/ Multiple],
  100.0 * SUM(CASE WHEN AnswerCount > 1 THEN 1 ELSE 0 END) / COUNT(*) as [% w/ Multiple As]
FROM Posts
WHERE 
  AnswerCount IS NOT NULL AND
  CreationDate >= '2022-01-01' AND
  CreationDate < '2022-11-01'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results