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;