Complex SQL Query

thanks alot! You are smart, I am dumb!

results below all in one table: