nuances of the subquery