Ellen wants to know how many books each author wrote. Write a SQL statement to provide such information to Ellen.

Ellen Novotny started an online bookstore in 2023. You are Ellen’s best friend and promised to help her. Ellen asked you to create a small database to track the information on books and authors. You created the following tables: Author, Book, and Author_ Book. The table Author_Book is a relationship table to link the Author table and Book table because of the many-to-many relationship between the two tables. That is, each author may write many books and each book may have multiple authors. In general, each customer can purchase many books in a single transaction. Also, copies of the same book can be sold to different customers. Once an order is processed, the books are shipped right away. Based on these tables you have (see below), help Ellen to extract the information she needs from the database.

Transcribed Image Text:

Author Author ID Last Name First Name Email AU-1 Adams Eric AU-2 Brown Jennifer AU-3 Davis Keith AU-4 Newport Kevin AU-5 Pham John AU-6 Sviokla Julia Book Book ID Title B-1 B-2 B-3 B-4 B-5 B-6 Accounting Principles Cost Management Accounting Information Systems Individual Taxation 2017 Intermediate Accounting Advanced Accounting Eric168@yahoo.com jenifferb@gmail.com keithd@gmail.com kevinn@hotmail.com johnpham@gmail.com jsviokla@yahoo.com Area Financial Accounting Management Accounting Information Systems Taxation Financial Accounting Financial Accounting Phone number (714) 833-2419 (619) 596-0012 (212) 342-5680 (301) 947-7741 (617) 645-3647 (805) 498-1688 Year Edition Publisher 2021 8 Wiley 2022 3 2022 2 2023 6 2021 1 2022 1 McGraw-Hill McGraw-Hill Pearson Wiley McGraw-Hill