Problem 109 Query to display the lowest average cost of books within a subject and the highest average cost of books within a subject. SELECT Min (AVERAGE_COST) AS "Lowest Avg Cost", Max...

Problem 109

Query to display the lowest average cost of books within a subject and the highest average cost of books within a subject.

SELECT Min (AVERAGE_COST) AS "Lowest Avg Cost", Max (AVERAGE_COST) AS "Highest Avg Cost"

FROM (SELECT BOOK_SUBJECT,Round(Avg (BOOK_COST),2) AS AVERAGE_COST FROM BOOK

GROUP BY BOOK_SUBJECT);

I got an error ERROR 1248 (42000) at line 1: Every derived table must have its own alias

How can I edit this query to make work? thanks

Extracted text: Lowest Avg Cost Highest Avg Cost 66.62 89.95

Jun 01, 2022

Get Answer To This Question