In usinhg"Execute Query" how do i deal with queries with a lot of sub queries? ( Query that contains a lot of sub queries)

Hi Sir Pablo, sorry for the newbie question. Is it ‘For Each Row’ or ‘For Each’?

I’ve been trying to use execute query on this query statement but the problem is it returns the incorrect number of items: