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 should select all customers whose city is not Pleasantville. The correct syntax for this is to use the <> operator, which means "not equal to" in SQL. The correct query that achieves this is Choice C.

Based on the Table Below, the Query That Finds All