Display the book category, publisher name and average price for books which belong to the either a category of COMPUTER or CHILDREN and where the

Question

37 users unlocked this solution today!

Display the book category, publisher name and average price for books which belong to the either a category of COMPUTER or CHILDREN and where the average retail cost for the category is more than 50 dollars. Rename the calculated field AVERAGE_CAT_PRICE and format with a leading $ symbol and rounded to two decimal places. Order the result by book category ascending and average category price descending

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