can i get help with database query question, please, i have the ERD and The tables that cant be seen the ERD

List the id and names of all publishers and the isbn and book title of all books the library has a record of. Include all publishers that the library does not currently stock a book from.

List any member who has checked out a book by publisher Anchor. Display the member id, first name, and last name. DO NOT JOIN the publisher table to the query.

How many books does the library own by author Julia Alvarez? DO NOT use a join.

Use a natural join to show all columns from book and publisher for publisher 2007.

List the member id, first name and last name of all members who have fees higher than $3.00. DO NOT use a join in your query.

The library sends a collection agency after members who keep an item longer than 2 years. List the member id, first and last name of all members who have fees due date is equal to or greater than 2 years ago based on today's date (using SYSDATE function) and never returned the book. DO NOT use a join for your solution.

Publisher PK Publisher_ID Author Member Book PK Author ID Name City State Zip PK Member ID PK,FK2 ISBN First Last DOB Gender First Last DOB Gender Affiliation Member since Title Edition Publisher ID Pub date Num pages Media Fiction Language FK1 Loan Book Author PK,FK2ISBN PK,FK1Member ID PK PK,FK1 ISBN PK,FK2 Author ID Check out date Position Due date Return date Fees