ADP interview question

oops sql concepts like union union all,rank etc