Question

Which of the following will display all books that were published at least three years before they were ordered?

a) SELECT * FROM BOOKS WHERE YEAR(OrderDate) - YEAR(PublicationDate) >= 3
b) SELECT * FROM BOOKS WHERE OrderDate - PublicationDate >= 3
c) SELECT * FROM BOOKS WHERE DATEDIFF(OrderDate, PublicationDate) >= 3
d) SELECT * FROM BOOKS WHERE PublicationDate - OrderDate >= 3

Answer 1

The correct SQL query is option a) SELECT * FROM BOOKS WHERE YEAR(OrderDate) - YEAR(PublicationDate) >= 3.

Step-by-step explanation:

The correct SQL query to display all books that were published at least three years before they were ordered is option a) SELECT * FROM BOOKS WHERE YEAR(OrderDate) - YEAR(PublicationDate) >= 3.

In this query, the YEAR() function is used to extract the year from the OrderDate and PublicationDate columns, and the subtraction is used to calculate the difference in years between the two dates. If the difference is greater than or equal to 3, then the book is displayed as a result.