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');

Name: 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');
Brand: Quizplus
Rating: 4.8 (41 reviews)

Question

Quizplus · Accepted Answer

The subquery is missing a FROM clause specifying the table to select from, which will cause a syntax error.

The Following Query Will Execute Without Errors