HDFC Bank Interview Question

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