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