• Well, you provided DDL and sample data, but I'm not quite sure what you expect as output. Please provide expected results based on the sample data you provided.