If you post the following:

1. Create table ... -- for all tables in the queries

2. Insert into ... -- to populate the tables with sample data

3. expected results

we can take a look at it