Report question

Question: Nested Select statement in MYSQL join