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