Please provide:
1. DDL in the form of CREATE TABLE statements to create your sample tables
2. DML in the form of INSERT INTO statements to populate the sample tables
3. The expected results of your SELECT statements based on that sample data
4. Most importantly: what you have tried so far.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato