Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________. Customer table A)SELECT * FROM Customer WHERE City NOT 'Pleasantville' B)SELECT * FROM Customer WHERE NOT (City = 'Pleasantville') C)SELECT * FROM Customer WHERE City 'Pleasantville' D)SELECT * FROM Customer WHERE City != 'Pleasantville'

Question

Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________.
Customer table
  
A)SELECT * FROM Customer WHERE City NOT 'Pleasantville' 
B)SELECT * FROM Customer WHERE NOT (City = 'Pleasantville') 
C)SELECT * FROM Customer WHERE City <> 'Pleasantville' 
D)SELECT * FROM Customer WHERE City != 'Pleasantville'

Quizplus · Accepted Answer

The query needs to retrieve all customers who do not live in Pleasantville. The NOT operator is used to negate the condition specified after it. Option A is incorrect because it is missing the equal sign in the condition. Option B is correct, but it is more complicated and can be simplified by using the not equals operator "<>". Option D is also correct, but the not equals operator is preferred for string comparisons. Therefore, the best choice is C.

Based on the Table Below, the Query That Finds All