SQL OFFSET is 0-based, but N (1st, 2nd, 3rd highest) is 1-based
Eg:
N = 1 → OFFSET = 0 (highest salary)
N = 2 → OFFSET = 1 (2nd highest salary)
Write a #SQL to find the nth highest distinct salary from the Employee table. If there are less than n distinct salaries, return null
Write a #SQL query to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead.