a

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

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 meta site
loading Hold tight while we fetch your results