Re: How to view number of available books in a library DB?

[Peter Brawley]

?! Nothing stops you from writing table specs in English.

Given tables books(bid, n, ...) and lent((lid,bid,lentdate,returndate,...) where lent.bid refers to books.bid, is this what you mean?

select b.bid, count(*)
from books b
join lent l using(bid)
where l.returndate is null
group by b.bid
order by b.bid;