average problem 1

[welshspoon]

hi

i need to find records with an average price greater than $10. I've managed to get the average price for each group and print it to screen but I cannot work out how to display only those records with an average greater than 10.

SELECT stor_id, CAST(AVG(Price)
AS numeric(12,2)) AS avg_price
FROM Stocks
GROUP BY stor_id

Thanx in advance

 

[SantaMufasa]

Spoon,

Try this code:

SELECT stor_id, avg(price) avg_price
from stocks
group by stor_id
having avg(price)> 10;

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.