duda con group by

[FNX_NET]

amigos

tengo este select

select price, title
from titles
where price > (select avg(price) from titles )
order by price


pero si quiero hacer esto

select price, title
from titles
where price > (select avg(price) from titles )
group by proce
order by price

me manda un error, ahora me gustaria saber porque, ya que estoy aprendiendo sql.

Saludos

[Nano_]

Saludos

Es por que es group by price y no group by proce, de no ser ese el error postea el que te indica el DBMS

[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