Exercise 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT TOP 10 t.Id, tagName, COUNT(p.Id) as PostCount
FROM tags as t
JOIN posts as p
ON t.Id = p.OwnerUserId
GROUP BY t.Id, tagName
ORDER BY PostCount DESC

Enter Parameters

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