[ad_1]
you can try sth like this
SELECT customers FROM orders WHERE price > (select AVG(price) from orders) ;
[ad_2]
solved I want to select customers whose price is higher than the average price
[ad_1]
you can try sth like this
SELECT customers FROM orders WHERE price > (select AVG(price) from orders) ;
[ad_2]
solved I want to select customers whose price is higher than the average price