Write the following SQL queries for the Bookstore$/$Library Management System on MS Access. You need to include SQL commands and outputs of all queries in the hardcopy of the submission. Softcopy has to be MS Access file.

You have to assume that, the current date is December $15,2023,$ while writing the SQL commands.

You can use "Top" function in SQL while answering the question.

SELECT TOP clause is used to specify the number of records to return.

For example SELECT TOP $2$ returns first $2$ rows from the resulting list.

$1.$ Find the names of person having at least $2$ checkouts during last month.

$2.$ Find the person paying late fee most during last month.

$3.$ Find the most $2$ preferable$/$popular books

$4.$ Find the book names with at least $2$ Authors, list authors of the books as well.

$5.$ What is the total revenue for the last week?

$6.$ Which books have no hold at this moment, List them by book names in descending order

$7.$ Which books has checked out and not returned. How many days they are late. List them by book names in ascending order

$8.$ Which books are not available on Jan $5$th$,2024$

$9.$ Find names of the person who put hold most at this moment

$10.$ Find publisher names having more than $2$ books at the Library.