PERCENTILE_DISC

1
SELECT
2
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY rating) as median_rating
3
FROM reviews;

1
SELECT
2
  PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) as p50_cont,
3
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY price) as p50_disc
4
FROM products;

1
SELECT
2
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY signup_date) as median_signup_date
3
FROM users
4
WHERE signup_date >= '2024-01-01';