Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ellen Wants to know how many books each author Wrote. Write an SQL statement to provide such information to Ellen use the two pictures
Ellen Wants to know how many books each author Wrote. Write an SQL statement to provide such information to Ellen
Ellen Novotny started an online bookstore in 2017. 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. Author Author ID Last Name First Name Email Phone number AU 1 Adams Eric Eric 16Bayahoo.com (714) 833-2419 AU-2 Brown Jennifer Jenifferbagmail.com (619) 596-0012 AU 3 Davis Keith Keithdogmail.com (212) 342-5680 AU-4 Newport Kevin kevinnohotmail.com (301) 9477741 AU.5 Pham John johnphamo gmail.com (617) 645-3647 AU-6 Svioko Julia Jsvioklodyahoo.com (805) 498-1688 115 Book Book ID Title Area Yer Edition Publisher Accounting Principles Financial Accounting 20168 Wiley B-2 Cost Management Management Accounting 2017 McGraw 2-3 Accounting Information Information Systems 2017 2 McGraw Hi Systems 3-4 Individual action 2017 Tovation 20156 Pearson 05 Intermediate Accounting and Accounting 20161 Wiley B-6 Advanced Accounting Financial Accounting 2017 McGraw 1 Author_Book Author ID Book AU 1 8-2 AU 1 B-5 AU-2 3-6 AU3 B-2 AL 3 AU4 B-2 AUS 84 AUG 31 8-6 AU-6 Customer Customer ID Last Name First Name Email C-1 B Emily Ew2003 yo.com 02 Brown Jack ciackmail.com Eston And ndersonnel.com Jenn May hotmail.com Vonale Judy way Venema.com C-6 White Ashley Ashley20150yahoo.com CH Wiliams Enc Wiliam_enyhoo.com 833 Sales_LineItem Sales Date Customer D Book ID Quantity Unit price 9/11/2017 07 Ba 1 5205 91/2017 C-7 3-1 1 5221 9/1/2017 C1 30 $195 92/2017 CS 32 60 $199 92/2017 C.5 B-5 25 5210 92/2017 82 1 $245 9/2/2017 1 5215 9/2/2017 C-3 3-4 1 $160 9/3/2017 ca B1 1 $221 116 " use the two pictures to answer the question "
"Accounting information system Question "
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started