Contents of the BOOKS table

-Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?
A) SELECT SUM(isbn) FROM books WHERE pubid = 3;
B) SELECT TOTAL(*) FROM books WHERE pubid = 3;
C) SELECT COUNT(pubid) FROM books WHERE pubid = 3;
D) none of the above

Question

Contents of the BOOKS table​
 
-Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?​
A) ​SELECT SUM(isbn) FROM books WHERE pubid = 3; 
B) ​SELECT TOTAL(*) FROM books WHERE pubid = 3; 
C) SELECT COUNT(pubid) FROM books WHERE pubid = 3; 
D) ​none of the above

Quizplus · Accepted Answer

The COUNT function is used to count the number of rows that match a specific condition. In this case, we want to count the number of books provided by publisher 3, so we can use the following query:

SELECT COUNT(pubid)
FROM books
WHERE pubid = 3;

This will return a single value, the count of books provided by publisher 3. Choice A is incorrect because the SUM function adds up the values in a specific column, and we cannot add up ISBNs to get the number of books. Choice B is incorrect because there is no TOTAL function, and we cannot use * to select all columns to get the count of books.

Contents of the BOOKS Table​

Contents of the BOOKS Table