• This seems to be a correlated sub-query. Does this apply to non correlated sub-query?