Write a SQL query to show the names of the patron, the checkout date,the book number, and
Question:
Write a SQL query to show the names of the patron, the checkout date, the book number, and book title who happened to check out the same book more than once. (e.g., the two patrons both checked out book x and both also checked out book y, maybe in different time periods.) That means the patrons have common interests. Include your name as a patron.
7. Write a SQL query to list the name of authors and patrons who checked out two or more books from this same author. That means the patrons like the author. Include your name as an author.
8. Write a query to show the top 5 books that have been checked out most often. List the book title and the number of checks out in descending order.
9. Write a query to list all book titles that have been checked out both in April and May of 2021.
10. Write a query to list all patrons who ever check out two or more books. Make your name included.
Accounting Information Systems
ISBN: 978-1260153156
2nd edition
Authors: Vernon Richardson, Chengyee Chang, Rod Smith