All Java Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

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

SELECT
    u.Id AS [User Link],
    COUNT(*) AS NumberOfAnswers
FROM
    Posts a
JOIN
    Users u ON a.OwnerUserId = u.Id
JOIN
    PostTags pt ON a.ParentId = pt.PostId
JOIN
    Tags t ON pt.TagId = t.Id
WHERE
    a.PostTypeId = 2 -- Samo odgovori
    AND t.TagName = 'java' -- Samo pitanja s tagom 'java'
GROUP BY
    u.Id
ORDER BY
    NumberOfAnswers DESC;

Enter Parameters

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