1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select
  datefromparts(year(dq.CreationDate), month(dq.CreationDate), day(dq.CreationDate)),
  count(q.Id) as [Open], count(dq.Id) as [All]
from PostsWithDeleted dq
left join Posts q on q.Id = dq.Id and q.ClosedDate is null
--left join Posts a
where dq.PostTypeId = 1
group by year(dq.CreationDate), month(dq.CreationDate), day(dq.CreationDate)
order by year(dq.CreationDate), month(dq.CreationDate), day(dq.CreationDate)

view current version

edited feb 16 17

created feb 16 17 amaranth