wae

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

with UserPostCounts as (
    select users.displayname, count(posts.owneruserid) as post_count 
    from users, posts
    where posts.owneruserid = users.id and location = 'russia'
    group by users.displayname
    having count(posts.owneruserid) > some(
        select count(posts.owneruserid) from users, posts
        where posts.owneruserid = users.id and location = 'poland'
        group by users.displayname
    )
)
select top 5 displayname, post_count from UserPostCounts
order by post_count desc;

Enter Parameters

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