0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

select age, AVG(reputation) rep_mean, VAR(reputation) rep_var, STDEV(reputation) rep_stddev 
from users
where age is not null and age between 15 and 75
and users.id in 
	(select users.id from users, posts answers where answers.posttypeid=1
		and users.id=answers.owneruserid and year(answers.creationdate)=2012
		)
 group by age

fork query

edited feb 15 13

created feb 15 13 anonymous