Your output should look like this:

$2)$ Write a query that JOINS three tables to list all of the books and the number of times each

book has been purchased. The results should include the ISBN, title, genre, the number of times

the book was purchased, and the total quantity of each book ordered. The query should select all

rows in the book table so if there are any books that have no records of being purchased

$($Unmatched rows$)$ are listed in the output as well. Sort the results by the ISBN.

$($Hint the total quantity is the sum of the order$\_$qty$)$

Your output should look like this:

ISBN Title Genre Number of Purchases

$979001$ Introduction to Electrodynamics Science $2$

$979002$ Understanding of Steel Construction Technology $2$

$979003$ Guide to Networking Computers $4$

$979004$ Transfer of Heat and Mass Technology $2$

$979005$ Conceptual Physics Science $0$

$979006$ Fundamentals of Heat Science $1$

$.......................$

$3)$ Modify the query in question $2$ to return the same results; however, only include the books