This should be done in SQL not MYSQL 1. Write statement which displays the title, category and
Question:
This should be done in SQL not MYSQL
1. Write statement which displays the title, category and the author(s) last name(s) of each books. If a book has multiple authors, the title and category should be listed with each of the author's last names. Order the results alphabetically by the book title
2. Write statement that displays the name of each category from the books table and the average retail price of books for that category. Order the results from the category with the highest average to the category with the lowest average.
3. Write statement that lists the order number, order date and the total number of books for that order (hint: be sure to use the quantity field as well as a group by). Order the results by increasing order number.
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman