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