0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select
  CAST (CreationDate AS DATE), 
  avg(score)
from Posts
where PostTypeId = 1 -- question
  and ClosedDate is null  
group by CAST (CreationDate AS DATE)
order by CAST (CreationDate AS DATE) desc

view current version

edited feb 20 20

created feb 20 20 Paulo Diogo