Display book title ISBN number and cost for all books which

Display book title, ISBN number and cost for all books which belong to the category with the least number of books in the category. Format the cost field as dollars ‘$’ with two decimal places. Rename the new formatted cost field to ‘COST’ (complex query). Order the result by book title.

ORDERS Order CUSTOMERS Customer Customer Orderd late Lastname Ship date Firstname Shipstreet Emal Shipcity Address Shipstate Shipzip BOOKAUTHOR AUTHOR State BOOKS Shipcost SBN AuthorlD Referred SBN AuthorID Lname ORDERITEMS Region Title Fname Order# Pubdate LA tem# Publ D SBN Cost Quantity Retail Discount PUBLISHER Category Paid each PublD Name PROMOTION Phone Contact Gift Minretaj Max retai FIGURE 1-5 JustLee Books\'s table structures after normalization

Solution

SELECT Title, ISBN, MIN(Category), CONCAT(\'Mr. \', Cost) AS numeric(36, 2) AS COST FROM BOOKS INNER JOIN ORDERITEMS WHERE 1 ORDERBY Title DESC;