Q1 - Number of Posts

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 top 1 (se.OwnerUserId),
count (se.Id) as sugEdit
from SuggestedEdits se, Posts p
where p.id=se.PostId
and p.PostTypeId = 2
and se.OwnerUserId <> p.OwnerUserId
Group By se.OwnerUserId
Order By sugEdit desc

Enter Parameters

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