Morgan Stanley interview question

A basic SQL join example