/* 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 5 *
from Comments
where CreationDate between '2017-07-16 00:00:00' and '2019-07-17 00:00:00'

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results