0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

select 
year(p1.creationDate),
count(p1.Id),
avg(p1.Score) as score_átlag,
stdev(p1.Score) as score_szoras,
avg(p1.ViewCount) as views_átlag,
stdev(p1.ViewCount) as views_szoras,
avg(datediff("hour", p1.CreationDate,p2.CreationDate)) as válaszidő_átlag,
STDEV(datediff("hour", p1.CreationDate,p2.CreationDate)) as válaszidő_szórás
from Posts p1, Posts p2
where p2.Id=p1.AcceptedAnswerId
and p1.Tags like '%C$#%' ESCAPE '$'
group by year(p1.CreationDate)
order by year(p1.CreationDate) desc

fork query

edited mar 2 anonymous

created feb 29 jon.doe43002