Write a query to display the lowest average cost of books within a subject and the highest average cost of books within a subject (Figure P7.109). FOR THIS PROBLEM

MY QUERY IS: SELECT ROUND(Max(Avg_Cost),2) AS "Highest Avg Cost", ROUND(Min(Avg_Cost),2) AS "Lowest Avg Cost" FROM

( SELECT AVG(BOOK.BOOK_COST) AS Avg_Cost

FROM BOOK 

GROUP BY BOOK.BOOK_SUBJECT);

Answer rating: 100% (QA)

Your query appears to be on the right track but there is a small issu... View the full answer