I don't have your tables, so those queries are not useful to me to create the data. Like I said, you need to provide create table statements and inserts for the data you need to have in them to produce your expected outputs.