-- Database schema
| Manufacturers : Code [ INT ] primary_key , Name [ TEXT ] , Headquarter [ TEXT ] , Founder [ TEXT ] , Revenue [ INT ] | Products : Code [ INT ] primary_key , Name [ TEXT ] , Price [ INT ] , Manufacturer [ INT ] Products.Manufacturer = Manufacturers.Code |
-- -- What are the average prices of products, grouped by manufacturer name?

SELECT avg(T1.Price) ,  T2.name FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer  =  T2.code GROUP BY T2.name;