Problem

Solution

1)

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE M INT;
SET M = N - 1;
  RETURN (      
      SELECT DISTINCT
        salary
      FROM Employee
      ORDER BY salary DESC
      LIMIT M, 1
  );
END