Nth Highest Salary Query

Tell me how you would write a MySQL query to get the nth highest salary without using row_number() or rank().

Use the employees table and demonstrate the query for n = 3. Equal salaries share one position, and rows with a NULL salary must be ignored.

Output

1. Return one column named nth_highest_salary.
2. Return one row for the third-highest distinct non-null salary.
3. Order the result by salary descending.