Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table,which of the following is a valid SQL statement?
A) SELECT contact Contact's Name FROM publisher;
B) SELECT publisherID FROM publisher;
C) SELECT contact,name FROM publisher;
D) SELECT name FROM publishers;

Question

Contents of the PUBLISHER table
  ​
-​Based upon the contents of the PUBLISHER table,which of the following is a valid SQL statement?
A) ​SELECT contact Contact's Name FROM publisher; 
B) ​SELECT publisherID FROM publisher; 
C) ​SELECT contact,name FROM publisher; 
D) ​SELECT name FROM publishers;

Quizplus · Accepted Answer

The table indicates that there are columns named "contact" and "name" in the PUBLISHER table, so option C is the only valid SQL statement that selects both columns. Option A is invalid because there is no column named "contact" with a space in the name. Option B is invalid because there is no column named "publisherID" in the PUBLISHER table. Option D is invalid because there is no table named "publishers".

Contents of the PUBLISHER Table