Display book title, Category, publisher name, author first name and author last name for all books that have been co-authored and the title of the book has letter SS anywhere and ends with letter Z. Order the result in ascending order by author last name.

Display the book Category and the average retail price after discount in all categories where average discounted price is less than the highest average retail price of books for all the categories. Sort the result in category order descending.

ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address Ci Sta Zi Referred Region BOOKAUTHOR AUTHOR BOOKS AuthornD Lname Fname AuthorlD ORDERITEMS Order# I tem# ISBN Quantity Paideach Title Pubdate PublD Cost Retail Discount Category PUBLISHER PublD Name PROMOTIO Contact Phone Gift Minretal Maxretail FIGURE 1-5 JustLee Books's table structures after normalization