select * from ( select OwnerUserId,Score,Title, dense_ran...


Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select *
from (
    select OwnerUserId,Score,Title,
    dense_rank() over(
     order by Score desc
    ) as rank_id
    from Posts p
     PostTypeId = 1 
    and ClosedDate >= '2021-09-01 00:00:00'
    and ClosedDate < '2021-10-01 00:00:00'  
     and exists (select 1 from Badges b where b.UserId = p.OwnerUserId )
   ) as t 
 where t.rank_id <= 50

Enter Parameters

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