What is the average price of products that cost between 100 and 200?
average price = DIVIDE(SUM(Price, COUNT(Price))); cost refers to Price; Price BETWEEN 100 AND 200;
SELECT AVG(Price) FROM Products WHERE Price BETWEEN 100 AND 200