phi

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select 
        FavoriteCount,
        OwnerUserId,
        OwnerDisplayName,
        row_number() over(order by FavoriteCount desc) as row_number
    from Posts
    where 
        OwnerUserId in (
            select 
                top 8 Id
            from Users
            where 
                Id in (
                select 
                    OwnerUserId
                from 
                    Posts
                where 
                    PostTypeId = 1
                    and Tags like '%bigdata%' or Tags like '%database%'
            )
        and Reputation >= 400000
        )
    and PostTypeId = 1
    and FavoriteCount is not null

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results