ADP Interview Question

oops sql concepts like union union all,rank etc