Help with SQL statement/Proc

Job ID: 33369351

Budget: $10 – $30 USD

I am having a problem getting my joins right in my SQL statement, I think I am close but I need a bit of help.
I have included the table structure and sample data and the query that I am getting stuck on. I didn't include relationships in the table but you should be able to see them in the query. Just contact me if you have additional questions.