Multiple Choice
Contents of the BOOKS table
-Based on the contents of the BOOKS table,which of the following will display the date of the book with the earliest publication date?
A) SELECT MIN(pubdate)
FROM books;
B) SELECT title
FROM books
WHERE pubdate = MIN(pubdate) ;
C) SELECT title
FROM books
WHERE pubdate = MINIMUM(pubdate) ;
D) SELECT MINIMUM(pubdate)
FROM books;
Correct Answer:

Verified
Correct Answer:
Verified
Q51: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q52: The AVG function can be used with
Q53: By default,the COUNT function uses the <u>DISTINCT</u>
Q54: Functions that return one result per group
Q55: The SUM function can only be used
Q57: Describe how the COUNT function processes NULL
Q58: The WHERE clause specifies which groups will
Q59: Group functions return a group of results
Q60: The _ clause can be used to
Q61: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"