SELECT * FROM Production.Product
WHERE StandardCost >
    (SELECT AVG(StandardCost) FROM Production.Product);