select year(p1.creationDate), count(p1.Id), avg(p1.Score)...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results