Based on the table below, the query that finds the names and zip codes of all customers is _____________________.
Customer table

A) SELECT ALL Name, Zip FROM Customer
B) SELECT Name, Zip
C) SELECT * FROM Customer
D) SELECT Name, Zip FROM Customer

Question

Based on the table below, the query that finds the names and zip codes of all customers is _____________________.
Customer table

A) SELECT ALL Name, Zip FROM Customer 
B) SELECT Name, Zip 
C) SELECT * FROM Customer 
D) SELECT Name, Zip FROM Customer

Quizplus · Accepted Answer

Option D is the correct SQL query to find the names and zip codes of all customers. It specifically selects only the Name and Zip column from the Customer table. Option A also retrieves the correct data, but the "ALL" keyword is unnecessary. Option B is incorrect because it does not specify the table to be used. Option C retrieves all columns from the Customer table, which is more data than needed for this question.

Based on the Table Below, the Query That Finds the Names