Answer 1

I've seen this task before (second highest salary)... is this homework ? Hints...

SQL has:
* functions like min(), max(), etc
and it can:
* sort a column ascending and descending (put numbers in order)
* limit the number of rows it returns (like, to just 1)
* compare one query's output (a subquery) to generate another answer using the familiar < and > tests.