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