duda con group by

[flaviovich]

Lo logico seria algo asi:

Código SQL:

SELECT title, MAX(price)
FROM titles
WHERE price > (SELECT avg(price) FROM titles )
GROUP BY title
ORDER BY title