Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________ Customer table A)SELECT Name FROM Customer WHERE City 'Pleasantville' B)SELECT Name FROM Customer WHERE City == 'Pleasantville' C)SELECT Name FROM Customer WHERE City

Question

Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________
Customer table
  
A)SELECT Name FROM Customer WHERE City 'Pleasantville' 
B)SELECT Name FROM Customer WHERE City == 'Pleasantville' 
C)SELECT Name FROM Customer WHERE City >< 'Pleasantville' 
D)SELECT Name FROM Customer WHERE City = 'Pleasantville'

Quizplus · Accepted Answer

To query the database for the names of customers who live in the city of Pleasantville, we need to select the Name column from the Customer table where the City column is equal to 'Pleasantville'. The correct syntax for the WHERE clause is to use a single equal sign (=) for comparison. Therefore, the correct statement is:

SELECT Name FROM Customer WHERE City = 'Pleasantville'

Based on the Table Below, Insert the Statement That Queries