Questions

Download the database bookstore.mdb$.$ This database keeps track of the inventory of books, orders, and customers in a bookstore.

Create a SQL query for each of the questions below. First, run the code on Ms Access, then copy the code to a Word file, and finally, after you have all codes, convert the Word file to a PDF and submit it$.$

Note: Assign aliases in the queries whenever necessary $($please use a short name that briefly describes the information on the corresponding column$).$

$1.$ For every book authored by C$.$J$.$ Cherryh, show the ISBN, title, and publication year. Sort the books by title in alphabetical order.

$2.$ Show the orders placed by the customer with customer number $2.$ Sort the orders by date.

$3.$ Show the total number of copies on hand $($by summing number$\_$on$\_$hand$)$ the bookstore has.

$4.$ Show the total number of titles authored by Anne Rice offered by the bookstore.

$5.$ Show the number of orders from customer $11$ that have not yet been filled $($order$\_$filled is of Yes$/$No type, to compare simply do order$\_$filled $=$ Yes or order$\_$filled$=$No$).$