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 total number of different books offered by the bookstore.
3. 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).
4. for every single author, show the author's name and the total number of units sold from that author. sort the results in order of the number of books, with the largest number of books appearing first. the number of books column should have the heading "units_sold".
5. for every single book, show the title and the total number of units of that book sold. the number of books column should have the heading "units_sold".
6. for each order placed on or after july 1, 2016, show the order number, order date, the customer first and last name, customer phone, and total cost of that order and whether it was filled or not.
7. show the list of authors corresponding to books ordered on or after may 2016. the query should show each author only once.
8. for each customer show the first name, last name, and total amount spent in books. sort the results alphabetically by last name, with customers having the same last name sorted alphabetically by first name.
9. modify the query above to show customers only from ny and that have spent at least $100 in books.