Multiple Choice
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;
Correct Answer:

Verified
Correct Answer:
Verified
Q9: If a group function is used in
Q10: The <u>COUNT</u> function is used to total
Q11: A(n)_ clause cannot include a group function.<br>A)
Q12: The DISTINCT keyword cannot be used with
Q13: If a group function is used in
Q15: The COUNT function can only be used
Q16: The MAX functions returns the <u>smallest </u>value
Q17: Contents of the ORDERS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q18: Which of the following is not considered
Q19: The _ clause is used to restrict