Posts where self-answers put off other answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

possibly newbies who don't know what they are doing

Korean Language

Q&A for linguists, teachers and students of the Korean language

-- Posts with self-answers that have fewer than average other answers

select top 100 q.Id as [Post Link], q.AnswerCount, DATEPART(HOUR, q.CreationDate) as Hour
from Posts q
join Users u on q.OwnerUserId = u.Id
join Posts a on q.Id = a.ParentId and q.OwnerUserId = a.OwnerUserId
where q.AnswerCount < 2
order by a.CreationDate DESC

Enter Parameters

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