Fractal Interview Question

Joining multiple tables - SQL