I know this may sound stupid since I'm pretty new to Oracle and SQL, but I'm trying to do a query with an average price and it's keeps giving me the error that group function not allowed here. Could someone point me in the right direction here. This is what I have but it keeps giving me that error.
SELECT productID productName, price
FROM our_product
WHERE AVG(price)<price;