Can you please post the DDL (create table), some sample data as an insert statement and the expected results?

😎

What you have described so far isn't a complex task but it is quite elaborate having to set up the sample set in order to demonstrate a solution.