SELECT u.DisplayName AS [Username], COUNT(p.Id) AS [statu...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT
  u.DisplayName AS [Username],
  COUNT(p.Id) AS [status-review Count]
FROM Posts p
INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.Tags LIKE '%<status-review>%'
GROUP BY u.Id, u.DisplayName
ORDER BY COUNT(p.Id) DESC;

Enter Parameters

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