Question

SQL questions. Select the appropriate letter/option only. Multiple choice.

1.Which of the following statements identifies the syntax error in this query?
select Lastname, Firstname
from charity.donors
where Donation > 1000 and;
Lastname not in select Lastname
from charity.current;
a. The subquery requires a semicolon prior to the SELECT statement in the WHERE clause.
b. The subquery has an extra semicolon after the AND operator.
c. The subquery must reside inside a HAVING clause.
d. The subquery must reference the same table as the outer query.

Answer 1

The syntax error in the query is in option a. The subquery requires a semicolon prior to the SELECT statement in the WHERE clause.

Step-by-step explanation:

The syntax error in the given query is in option a. The subquery requires a semicolon prior to the SELECT statement in the WHERE clause. In the original query, the subquery starts with 'Lastname' but is missing a semicolon before it. The correct syntax should be:

select Lastname, Firstname from charity.donors where Donation > 1000 and Lastname not in (select Lastname from charity.current);