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); --*/ /* 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); --*/ --/* select * from Votes q --- join Votes v on PostId = q.Id where -- PostTypeId = 1 --and VoteTypeId = 3 --and UserId = ##ID## -- select * from extra_rep --*/