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

Select the average price of each manufacturer's products, showing the manufacturer'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" AS "T1" JOIN "Manufacturers" AS "T2" ON "T1"."manufacturer" = "T2"."code" GROUP BY "T2"."name"