Morgan Stanley interview question

simple sql stuff, some stuff about execution plan.