instruction: Number of Resolved Qs where solution is not the first A.
response: WITH resolved_Qs AS (SELECT Id AS ResolvedQuestionId, AcceptedAnswerId, Score FROM Posts WHERE PostTypeId = 1 AND AnswerCount > 0 AND NOT AcceptedAnswerId IS NULL), topScores AS (SELECT MAX(Score) AS TopScore, ParentId AS QuestionId FROM Posts WHERE PostTypeId = 2 AND NOT ParentId IS NULL GROUP BY ParentId), topScorerAcceptedAs AS (SELECT AcceptedAnswerId, ResolvedQuestionId, Score FROM resolved_Qs INNER JOIN topScores ON resolved_Qs.ResolvedQuestionId = topScores.QuestionId WHERE resolved_Qs.Score = topScores.TopScore) SELECT (SELECT COUNT(*) FROM resolved_Qs) - (SELECT COUNT(*) FROM topScorerAcceptedAs) AS difference UNION SELECT COUNT(*) FROM resolved_Qs UNION SELECT COUNT(*) FROM topScores