By Date Number of Users who posted and who did not, reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sustainable Living

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

(select 'No' as [Category], convert(date, u.CreationDate) as [Creation Date], count(u.Id) as [count], avg(cast(u.Reputation as float)) as [Average Reputation]
from Posts p right join Users u on p.OwnerUserId = u.Id 
where p.ClosedDate is null and p.DeletionDate is null and p.OwnerUserId is null 
group by convert(date, u.CreationDate)
)
UNION
(select 'Yes' as [Category], convert(date, u.CreationDate) as [Creation Date], count(u.Id) as [count], avg(cast(u.Reputation as float)) as [Average Reputation]
from Posts p inner join Users u on p.OwnerUserId = u.Id 
where p.ClosedDate is null and p.DeletionDate is null  
group by convert(date, u.CreationDate)
)

Enter Parameters

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