0

Please login or register to vote for this query.

(click on this box to dismiss)

Perguntas e respostas para programadores profissionais e entusiastas

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

fork query

edited feb 20 20

created feb 20 20 Paulo Diogo