0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

select distinct percentile_disc(0.5) 
         within group (order by Reputation)
         over () "Median reputation"
from Users u
where u.Id in (select distinct OwnerUserId
               from Posts q
                    join Votes v on PostId = q.Id
               where PostTypeId = 1
                     and VoteTypeId = 3)

view current version

edited oct 18 19

created oct 18 19 Jon "not doe" Ericson