You will have better luck getting some help here with your own, genuine attempt to do your own homework. I, along with others, do not see a productive use of time in doing homework for somebody who cannot be bothered to make a reasonable effort on their own. So, my advice is: Study the materials you were assigned for this part of the course; write some queries that have some chance of working according to your understanding; if they work, you are done; otherwise, show your not-quite-right queries and ask specific questions about why the results you get differ from the results you wanted. If it does not become obvious during your assigned study, do some research on the meaning and uses of the JOIN keyword in SQL.