CREATE TABLE products (Name VARCHAR2, Price NUMBER, manufacturer VARCHAR2)
CREATE TABLE Manufacturers (name VARCHAR2, code VARCHAR2)

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" "T1" JOIN "Manufacturers" "T2" ON "T1"."manufacturer" = "T2"."code" GROUP BY "T2"."Name"