For future reference, please follow the guidelines here:
If this is for a class or exam, we don't answer those questions on SQLTeam.com. At the very minimum you would need to post what you have attempted so far, and examples of data that demonstrate why it's not working as intended.
2 Likes