I need help with joing two tables to get the results which is the author name and what booked he borrowed

Author Table

INSERT INTO Author VALUES (12,'James Smith' );


Using join conditions
Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH)

imaginary language into java. I have everything down except for the symbol table.

I am currently making ERD diagram for a library . The entities are below:

Entity Attributes
Member...