nested joins check

[jobo]

Which way to start complex joins is a difficult question.
In general I would start with the answer:
It's oracle, the optimizer works quite well, so don't care about performance etc.
Just use a join style, which suits You and Your understanding of the model / use case.

If you have a working statement You can start tweaking.

Btw. it's also possible and very helpfull to build views, doing certain steps of abstraction, explanatione etc.
Starting with a better naming of columns, you can later maybe reuse some of them at a certain stage. This could lead to better consistency and "stability".