Contents of the BOOKS table

-Based upon the contents of the BOOKS tables,which of the following SQL statements will return the number of different publishers represented in the table?
A) SELECT COUNT(DISTINCT pubid)FROM books;
B) SELECT DISTINCT COUNT(pubid)FROM books;
C) SELECT DISTINCT (COUNT(pubid))FROM books;
D) SELECT (DISTINCT COUNT(pubid))FROM books;

Question

Contents of the BOOKS table​
 
-Based upon the contents of the BOOKS tables,which of the following SQL statements will return the number of different publishers represented in the table?​
A) ​SELECT COUNT(DISTINCT pubid)FROM books; 
B) ​SELECT DISTINCT COUNT(pubid)FROM books; 
C) ​SELECT DISTINCT (COUNT(pubid))FROM books; 
D) ​SELECT (DISTINCT COUNT(pubid))FROM books;

Quizplus · Accepted Answer

The correct SQL statement to return the number of different publishers represented in the BOOKS table is to use the COUNT function with the DISTINCT keyword on the pubid column. This means that only unique values of pubid will be counted. Option A is the correct SQL statement that follows this logic. Option B and C are incorrect because they first count all pubid values and then apply DISTINCT, which will not give the correct count. Option D is incorrect because the order of DISTINCT and COUNT functions is reversed.

Contents of the BOOKS Table​

Contents of the BOOKS Table