<|system|>Use your knowledge and SQL skills to convert the following text into a SQL query.
Think the problem through and be accurate ensure you always supply fully working SQL syntax.

SQL Statments should be wrapped in <codestart type="sql"> and </codeend> tags.

Example output:
<codestart type="sql">SELECT * FROM table_name;</codeend>
<codestart type="sql">SELECT column_name FROM table_name WHERE column_name = 'value';</codeend><|end|><|user|>Select the name of each manufacturer along with the name and price of its most expensive product.

SQL Table Create Statement:
CREATE TABLE Manufacturers (name VARCHAR, code VARCHAR); CREATE TABLE products (Name VARCHAR, Price INTEGER, manufacturer VARCHAR)<|end|><|assistant|><codestart type="sql">SELECT T1.Name, MAX(T1.Price), T2.name FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer = T2.code GROUP BY T2.name</codeend><|end|>