Assuming a library database schema with the following tables and attributes:

Book (BookID, Title, AuthorID, PublisherID, Rating, Price)

Author (AuthorID, FirstName, LastName)

Publisher (PublisherID, Name)

Borrower (BorrowerID, FirstName, LastName)

1. Write a SQL query to retrieve the names of all authors who have written a book published by "Penguin Books".
2. Write a SQL query to retrieve the total number of books borrowed by each borrower.
3. Write a SQL query to retrieve the names of all publishers who have published at least one book with a rating of 4 stars or higher.
4. Write a SQL query to calculate the average price of books.
5. Write a SOL query to find the maximum price of books.

PLEASE ANSWER CORRECTLY OR I WILL PUT

Assuming a library database schema with the following tables and attributes: Book (BookID, Title, AuthorID, PublisherID, Rating, Price) Author (AuthorID, FirstName, LastName) Publisher (PublisherID, Name) Borrower (BorrowerID, FirstName, LastName) 1- Write a SQL query to retrieve the names of all authors who have written a book published by "Penguin Books". 2- Write a SQL query to retrieve the total number of books borrowed by each borrower. 3- Write a SQL query to retrieve the names of all publishers who have published at least one book with a rating of 4 stars or higher. 4- Write a SQL query to calculate the average price of books. 5- Write a SQL query to find the maximum price of books