我现在遇到了一个问题,需要在Postgres上计算中位数,但是Postgres没有关于计算中位数的函数。以下是我的查询语句,我想要得到该查询结果的中位数,请帮我解决这个问题。
SELECT count, conversion, company_id FROM (SELECT count(ap.id),
(count(ap.id)/cast(NULLIF(SUM(j.views), 0) as float) * 100) AS conversion,
j.company_id FROM applications ap RIGHT JOIN jobs j ON ap.job_id = j.id GROUP BY j.company_id order by conversion) with_avg