Hexaware Technologies interview question

2nd highest salary, broadcast join, catalyst optimizer, salting