use library
select isbn, sum(noOfCopies) as 'Number of copies'
from dbo.Available
group by isbn