Using a subquery in FROM (a derived table), show genres whose average price exceeds 15. Columns: genre, avg_price. Order by avg_price descending.

Answer

SELECT genre, avg_price FROM ( SELECT genre, avg(price) AS avg_price FROM books GROUP BY genre ) g WHERE avg_price > 15 ORDER BY avg_price DESC;