Top users in number of answers in homework

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(t2.score) as number_of_answers, t2.owneruserid
FROM posts AS t1 INNER JOIN posts AS t2
ON t1.id = t2.parentid
WHERE t1.tags LIKE '%<homework>%'
GROUP BY t2.owneruserid
ORDER BY number_of_answers DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results