Morgan Stanley Interview Question

simple sql stuff, some stuff about execution plan.