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 avg(score) asc

view current version

edited feb 20 20

created feb 20 20 Paulo Diogo