0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

-- tags/scores/users
select tags.tagname, users.age age, 
cast(count(distinct users.id) as float) nusers, 
--cast(sum(users.reputation) as float) reputation, 
--cast(sum(posts.score) as float) score,
cast(count(distinct posts.id) as float) posts
from users, posts, posttags, tags 
where
users.age is not null and users.age between 10 and 70
and users.reputation > 1000 
and year(posts.creationdate)=2012
and posts.id = posttags.postid
and posttags.tagid=tags.id
and tags.tagname = 'lisp'
group by tags.tagname, users.age
having cast(sum(posts.score) as float) > 10.0

view current version

edited mar 5 13

created mar 5 13 anonymous