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 distinct top 10 UserId, Name
group by UserId, Name, Class
having Class > 2
order by Name
--where CreationDate between '2017-07-16' and '2019-07-17'