How many times has the book with ISBN “0-321-52306-7” been borrowed?
What will be an ideal response?
SELECT COUNT(*)
FROM BookCopy bc, BookLoan bl
WHERE bc.copyNo = bl.copyNo AND ISBN = ‘0-321-52306-7’;
Computer Science & Information Technology
You might also like to view...
The bitwise AND operator & is often used to ________ bits (i.e., to select certain bits from a bit string while zeroing others).
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
When renaming columns, you include the new column names in ____ following the name of the view.
A. single quotes B. double quotes C. parentheses D. square brackets
Computer Science & Information Technology