Hi there! Could some one help me with the SQL. I using 12c oracle developer. I included a ER digram to help with the tables and colums that are associated. Please provide comment so I can learn. thank you in advance.

1. Display the publisher, title and retail price of the most expensive book sold by each publisher (Hint: use the RETAIL column in the BOOKS table). Sort the results in descending order on the retail price

2. Display the title of all books that have not been ordered. Sort the results in alphabetical order. should give this out put:

There ER digagram as all the tables and coulums to those table.

Publisher Title 1 Reed-N-Rite Painless Child-Rearing 2 American Publishing Holy Grail Of Oracle 3 Publish Our Way Building A Car With Toothpicks 4 Printing Is Us How To Manage The Manager 5 Reading Materials Inc. Bodybuild In 10 Minutes A Day Retail Price $89.95 $75.95 $59.95 $31.95 $30.95 Unsold Books 1 Building A Car With Toothpicks 2 How To Get Faster Pizza 3 The Wok Way To Cook CUSTOMERS Customer Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN Authorld ISBN IN AuthorID Lname Title Frame Pubdate PubID Cost Retail Discount PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretail Maxretail