M&G Investments interview question

SQL window functions, query to find second largest number