SELECT * FROM customer WHERE age > (SELECT AVG(age) FROM customer);

SELECT * FROM customer WHERE age > AVG(age);

SELECT * FROM customer HAVING age > AVG(age);

SELECT * FROM customer WHERE age IN (AVG(age));