Quote:
Originally Posted by OPI
Okay that totally makes sense.. buutt
Here's what I'm getting.
http://imgur.com/pGp7Gd5
Not sure why but it's giving me an error
|
Not sure of Oracle syntax (was a sql server programmer) but, on reflection, I may have over complicated my answer.
Try
Select name
From customers as customer1
Where rating is not null and
rating is < (select avg(rating) from customer as customer2 where dating is not null)