Are the answers I have bolded correct (look at relationship table) if they are not correct please post the answer. Please use the relationships provided in the picture. Every answer I have been given wont run it shows an error.

Query 2: Give ISBN and Title for books currently loaned out.

SELECT Book.ISBN, BookCardCatalog.Title FROM Book, Borrower, BookCardCatalog WHERE Book.SSN = Borrower.SSN AND BookCardCatalog.ISBN = Book.ISBN; 

Query 4: How many books by first authors whose name includes MAN are checked out?

SELECT BookCardCatalog.1stAuthor, COUNT(BookCardCatalog.Title) FROM Book, Borrower, BookCardCatalog WHERE Book.SSN = Borrower.SSN AND BookCardCatalog.ISBN = Book.ISBN AND BookCardCatalog.1stAuthor LIKE '%MAN%' GROUP BY BookCardCatalog.1stAuthor; 

Query 7: List titles covering both subjects GEOG and GEOL.

SELECT BookCardCatalog.Title, covers.SubjectID FROM BookCardCatalog, covers WHERE BookCardCatalog.ISBN = covers.ISBN AND covers.SubjectID = 'GEOG' AND covers.SubjectID = 'GEOL';

Relationships X Borrower ISSN Name Address 1 Subject/Topic SubjectID SubjectDescription BookCardCatalog ISBN Title 1stAuthor Publisher YearOfPublication Book 00 o ISBN 1 Copy# SSN DateCharged Out DateDue covers ISBN 1 SubjectID