Select U.Id,U.DisplayName, U.UpVotes, count(P.Id) as tota...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

Select U.Id,U.DisplayName, U.UpVotes, count(P.Id) as totalPosts
From Posts P
JOIN Users U
  ON(P.Id = U.Id)
Group By U.Id, U.DisplayName, U.UpVotes
Order By U.Id desc

Enter Parameters

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