Happy to help, but we don't like to do homework, tests, or work work for you. Make an attempt.

You haven't really explained how the data should be joined, or given any DDL/DML to help us set up a scenario. Most importantly, you didn't make any query attempt to get this to work yourself.