I'm not going to ask you for the DDL for the tables, or sample data, or expected results. I would like to see and ERD with the tables (including keys and data elements) so we can see how these tables relate to each other and perhaps show you another way to accomplish your task at hand that may not be as complex.