instruction: For each manufacturer, what are the names and prices of their most expensive product?, could you sort in ascending by the bars?
response: SELECT T1.Name, MAX(T1.Price) FROM Products AS T1 JOIN Manufacturers AS T2 ON T1.Manufacturer = T2.Code GROUP BY T1.Name ORDER BY Name