0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for amateur radio enthusiasts

select top 200
    users.id,
    users.displayname,
    count(posts.id) as ans,
    count(votes.id) as acc,
    1.0*count(votes.id)/count(posts.id) as pct
from users
        join posts on (users.id = posts.owneruserid)
        left join votes on (votes.postid = posts.id)
    and posts.posttypeid = 2
    and votes.votetypeid = 1
    group by users.id, users.displayname
    order by pct desc;

fork query

created aug 6 10 anonymous