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 tags.tagname, answerer.age age, 
count(distinct answerer.id) nanswerers, 
cast(sum(answerer.reputation) as float) reputation, 
count(distinct questions.id) nquestions, count(distinct answers.id) nanswers, 
cast(sum(answers.score) as float) score
from users answerer, posts questions, posts answers, posttags, tags 
where
answerer.age is not null and answerer.age between 10 and 70
--and answerer.reputation > 1000
and questions.posttypeid=1
and year(questions.creationdate)=2012
and questions.id = posttags.postid
and posttags.tagid=tags.id
and tags.tagname in ('silverlight', 'asp.net-mvc', 'json','linq','iphone',
'ios','xcode','ruby-on-rails', 'ocaml','django','mercurial',
'git','f#','windows-phone-7','android','clojure','github','mongodb')
and questions.id=answers.parentid
and answers.posttypeid=2
and answers.owneruserid=answerer.id
group by tags.tagname, answerer.age
having sum(answers.score) > 10

Enter Parameters

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