0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

--avg score of *answers*
select max(create_date) from sys.tables
/*
select
  eomonth(a.creationdate),
  count(a.id) as [# Answers],
  round(avg(1.0*a.score),2) as [Avg Answer Score]
from posts q left outer join posts a on q.id=a.parentid
where ( q.tags like '%vba>%' or q.tags like '%excel%' )
  and a.creationdate is not null
group by eomonth(a.creationdate)
order by eomonth(a.creationdate)

fork query

edited oct 15 18

created oct 15 18 ashleedawg