List the names of borrowers who currently have the book title “Lord of the Rings” on loan.
What will be an ideal response?
SELECT borrowerName
FROM Borrower bw, Book b, BookCopy bc, BookLoan bl
WHERE bw.borrowerNo = bl.borrowerNo AND bl.copyNo = bc.copyNo
AND bc.ISBN = b.ISBN AND bc.available = ‘N’ AND title = ‘Lord of the Rings’;
You might also like to view...
Every variable has a ______________ .
a) name b) type c) Both of the above. d) Neither of the above.
PowerPoint allows you to adjust colors to match or add contrast to slide elements by coloring photos.
Answer the following statement true (T) or false (F)
Which of the following is NOT a default setting for the taskbar?
A) the Clock icon is displayed B) live thumbnail previews are enabled C) Quick Launch toolbar displays D) similar items are grouped
You can use the command line, Windows ________, or remote methods to administera server running in Server Core mode
Fill in the blank(s) with correct word