/* select p.OwnerDisplayName as 'Name', count(p.PostTypeI...


Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select p.OwnerDisplayName as 'Name',
       count(p.PostTypeId) as 'Count',
       u.EmailHash as 'EmailHash',
       u.Reputation as 'Rep'
from Posts p
join Users u on (p.OwnerUserId = u.id)
group by p.OwnerDisplayName, u.EmailHash, u.Reputation
having p.OwnerDisplayName is not null and p.OwnerDisplayName != ''
order by p.OwnerDisplayName

--select top 2 * from Posts

--select * from CloseReasonTypes

--select * from PostTypes

select top 1 * from Comments

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results