Question

The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book, which gives them exclusive access to the book online through the FACT website, but only one patron at a time can have access to a book. A book must have at least one author but can have many. An author must have written at least one book to be included in the system but may have written many. A book may have never been checked out but can be checked out many times by the same patron or different patrons over time. Because all faculty and staff in the department are given accounts at the online library, a patron may have never checked out a book or they may have checked out many books over time. To simplify determining which patron currently has a given book checked out, a redundant relationship between BOOK and PATRON is maintained.

Required:
Write a query that will display all the Books that were published in 2016.

Answer 1

Select BOOK_TITLE, BOOK_YEAR, BOOK_SUBJECT from book order by BOOK_SUBJECT asc, BOOK_YEAR desc, BOOK_TITLE asc;

BOOK_PUBLISH 2016;

Step-by-step explanation:

The books subject will be displayed in ascending order, book year will be displayed in descending orders and book title will be displayed in ascending order. The query used will display all the books entered in the system. If there is specific year in which the search is used then the query will be update with year number instead of year such as BOOK_PUBLISH, 2016; This will show the list of all books that are published in 2016.