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

0

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 '7/15/2019' and '7/17/2019'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results