Tuesday, 6 March 2012

Using Function AVG()

SELECT Customer FROM Product
WHERE ProductPrice<(SELECT AVG(ProductPrice) FROM Product)

No comments:

Post a Comment