Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Vernon Richardson, Chengyee Chang, Rod Smith

2nd edition

1260153156, 1260153150, 978-1260153156

More Books

Students also viewed these Databases questions

Question

Is there statistical significance? What was the effect size?

Answered: 1 week ago