Sr. Director screwed it. He was not in a mood of selecting any candidate that day. May be he had a argument with someone. Rest all was perfect. They asked DBMS quesTion like rank and dense rank. Department wise 2nd highest salary. Lag vs lead