W3School TIY Editor

SELECT AVG(Price) FROM Products WHERE CategoryID = 1;