Well, i'm not the owner of the db, so it would be dificcult, do you
think that optimizer would do same the job, comparing to derived
tables, please?

Could you specify the meant JOIN approach in such situation, please?

Thank you for your experienced help.