I posted my whole sql query sorry if I didn't post the correct thing

the data I posted is the output I get when I run the query

I will try the where left statement

thank you