0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

select age, count(*) programmers, sum(reputation) total_reputation, sum(reputation)/count(*) normed_reputation 
from users
where age is not null and age between 18 and 70
and users.id in 
	(select users.id from users, posts answers where answers.posttypeid=2
		and users.id=answers.owneruserid and year(answers.creationdate)=2012
		and answers.parentid in 
			(select questions.id from posts questions, posttags, tags 
				where questions.id = posttags.postid
				and posttags.tagid=tags.id and tags.tagname = 'design-patterns'
			)
		)
group by age
order by age

fork query

edited feb 11 13

created feb 11 13 anonymous