Find the median salary of all employees.

Answer preview

Use the ordered-set aggregate PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary), which interpolates between the two middle values when the row count is even.…