HDFC Bank interview question

Basic Joins, 3rd highest salary, RANK(), window functions