W3School TIY Editor

SELECT MAX(Price) AS HighestPrice, CategoryID FROM Products GROUP BY CategoryID;