Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
question.Id as [Post Link],
question.Tags as [Tags],
COUNT(answers.Id) as [Answers],
MAX(answers.Score) as [Answer score]
FROM Posts question
INNER JOIN Posts answers
ON question.Id = answers.ParentId
WHERE question.PostTypeId = 1
AND question.Tags LIKE '%java%'
AND question.Tags NOT LIKE '%android%'
AND question.AcceptedAnswerId IS NOT NULL
-- AND question.Body LIKE '%Exception in thread%'
--HAVING accepted_answer.Score < MAX(answers.Score)
-- AND accepted_answer.Score > 0
COUNT(answers.Id) = 1
ORDER BY MAX(answers.Score) DESC