Amnet Digital interview question

Sql Queries on second highest salary and view table syntax.