--Retrieve details of all books in the library – id, title, name of publisher, authors, --number of copies in each Programme, etc. SELECT B.BOOK_ID, B.TITLE, B.PUB_NAME, A.AUTHOR_NAME,C.NO_OF_COPIES,L ...