In SQL, Please is this correct?
SELECT COUNT (Price)
FROM orders
WHERE Price > AVG(Price);
4
you can try sth like this
SELECT customers FROM orders WHERE price > (select AVG(price) from orders) ;
In SQL, Please is this correct?
SELECT COUNT (Price)
FROM orders
WHERE Price > AVG(Price);
4
you can try sth like this
SELECT customers FROM orders WHERE price > (select AVG(price) from orders) ;