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;

Question

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;

Quizplus · Accepted Answer

Option A uses the MIN function to select the earliest publication date from the pubdate column of the BOOKS table. It will return a single value which is the minimum value in the pubdate column, i.e., the date of the book with the earliest publication date. Option B is incorrect because it selects the title(s) of the book(s) with the minimum publication date, which could be more than one since multiple books could have the same earliest publication date. Option C is incorrect because there is no MINIMUM function in SQL, and Option D is incorrect because it selects the minimum value of the pubdate column, not the date of the book with the earliest publication date.

Contents of the BOOKS Table​

Contents of the BOOKS Table