Contents of the BOOKS table

-Based upon the contents of the BOOKS table,which of the following is a valid SQL statement?
A) select * FROM pubid;
B) select pubid,"Publisher ID" from books;
C) select pubid,isbn,from books;
D) none of the above

Question

Contents of the BOOKS table
 
-Based upon the contents of the BOOKS table,which of the following is a valid SQL statement?​
A) ​select * FROM pubid; 
B) ​select pubid,"Publisher ID" from books; 
C) ​select pubid,isbn,from books; 
D) ​none of the above

Quizplus · Accepted Answer

Option D is correct because options A, B, and C all contain syntax errors or incorrect references. Option A incorrectly references a table name instead of a column name. Option B uses double quotes incorrectly around a column alias, which should use single quotes or no quotes for identifiers. Option C has a syntax error with a comma before the FROM keyword.

Contents of the BOOKS Table