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