tags/age/recent

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

select age, count(*) programmers, 
 avg(cast(reputation as FLOAT)) avg_reputation, 
 stdev(cast(reputation as FLOAT)) stdev_reputation 
from users
where age is not null and age between 10 and 70
and reputation > 1000
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
order by age

Enter Parameters

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