Fractal interview question

Oops concepts, SQL joins