The Following Query Will Execute Without Errors

The following query will execute without errors.
select customer.customer_name, salesman.sales_quota
from customer
where customer.salesman_id =
(select salesman_id
where lname = 'SMITH');