First page Back Continue Last page Graphics
Library TC questions
Give the name and faculty of borrowers, and the ISBN-number of the books of which they were the first borrower.
Give the name and faculty of borrowers who have never borrowed the most recently purchased copy of a book.
Give the title of books that are “present” in the library, reserved by someone, but not yet borrowed (by anyone).
Notes:
Note that these questions are from the June 30, 2003 exam. (This exam is available with solutions, but these solutions are not all in SQL.)