11. List the isbn of the book, the id and firstname of the editors. Include all books in the bookeditor table. The image provides the structure of various tables in a database schema, likely used for managing books, authors, publishers, and editors. Below is a detailed description of each table and their relationships:### Tables and Fields:**1. Book Table**- **isbn**: varchar- **name**: varchar- **type**: varchar- **pub_id**: int- **price**: decimal- **advance**: decimal- **ytd_sales**: int- **pubdate**: date**2. Publisher Table**- **pub_id**: int- **name**: varchar(40)- **address**: varchar(40)- **city**: varchar(20)- **state**: varchar(2)**3. BookAuthor Table**- **author_id**: int- **isbn**: varchar- **author_order**: int- **royaltyshare**: decimal**4. Author Table**- **author_id**: int- **ssn**: varchar- **lastname**: varchar- **firstname**: varchar- **phone**: varchar- **address**: varchar- **city**: varchar- **state**: varchar- **zip**: varchar**5. BookEditor Table**- **editor_id**: int- **isbn**: varchar**6. Editor Table**- **editor_id**: int- **ssn**: varchar- **lastname**: varchar- **firstname**: varchar- **phone**: varchar- **editor_position**: varchar- **salary**: decimal### Relationships:- The `book` table uses `isbn` as a key to connect to both `bookauthor` and `bookeditor`.- The `bookauthor` table links `author_id` to the `author` table, establishing a relationship between books and authors.- Similarly, `bookeditor` links `editor_id` to the `editor` table, associating books with editors.- The `book` table uses `pub_id` to connect with the `publisher` table, indicating which publisher is responsible for a particular book.This schema allows for comprehensive tracking of relationships among books, authors, editors, and publishers, enabling efficient management within a library or publishing context.

Script to List the ISBN of the book, the id, and first name of the editors mentioned in step 2, and feel free to post follow-up questions in case you see any issues or errors with the script.script: select b.isbn, b.name, t.editor_id, t.firstname from book as b left join (select be.isbn,e.editor_id,e.firstname from bookeditor as be,editor as e where be.editor_id=e.editor_id) as t on b.isbn=t.isbn;