You tell us.

Try providing us with the DDL for the table(s), sample data for the table(s), and expected results based on the sample data you provide.

We can't see what you see, and we can't answer a question that we don't know what it is you are trying to accomplish.