Hi everyone, I'm really struggling with this and hoping someone can help me

AND I need to restate that I am a SQL noob!!

First attempt:

This query is returning all the data...

Steve thank you for your responses, sorry if I appear thick, I'm learning this by trial and error, against a system someone else built.

I think maybe I need to...

So you can't nest joins?