Marriott International Interview Question

name some complicated sql