0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people organizing, marketing or licensing open source development projects

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;

fork query

created may 19 anonymous