CREATE TABLE products (price NUMBER, Manufacturer VARCHAR2)
CREATE TABLE manufacturers (name VARCHAR2, code VARCHAR2)

Find the average prices of all products from each manufacture, and list each company's name.
SELECT AVG(T1.price), T2.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code GROUP BY T2.name
SELECT AVG("T1"."price"), "T2"."name" FROM "products" "T1" JOIN "manufacturers" "T2" ON "T1"."Manufacturer" = "T2"."code" GROUP BY "T2"."name"