The subquery returns all offices codes of the offices that locate in the USA. The outer query selects the last name and first name of employees whose office code is in the result set returned by the subquery.
The subquery returns all offices codes of the offices that locate in the USA. The outer query selects the last name and first name of employees whose office code is in the result set returned by the subquery.