Scotiabank Interview Question

how to find the second highest salary given the table structure