CREATE TABLE products (Name VARCHAR, Price INT, manufacturer VARCHAR)
CREATE TABLE Manufacturers (name VARCHAR, code VARCHAR)

Select the name of each manufacturer along with the name and price of its most expensive product.
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
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"