First page Back Continue Last page Graphics
Example:
(Library): give the name and department of every borrower who currently has books, together with the number of books not yet returned.
select b.name, b.department, count(b.barcode)
from borrow as b
where b.tot IS NULL
group by b.name, b.department
This is not the same as: give the name and department of every borrower, together with the number of books not yet returned. What is this question in SQL?
Notes: