Score médio zero

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

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