Write SQL to list all patrons and their number of transactions for each transaction type. Include all patrons even if they do not have transactions.

5. Write SQL to list the books with the word database or data base or databases in their title. Make your search case insensitive. Print the authors last name (mixed case) and the title. Sort the results by the rating.

6. Write a join command to display all the patrons with at least one book issued to them.

7. Write SQL to list all the books (book ids and first 10 characters of the title) and their total number of transactions in 2020. Include all books even ifthey have no transactions (count should be 0). Sort the results by the most popular book (the book with the most transactions).