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 <table_name> : Manufacturers col : Code | Name | Headquarter | Founder | Revenue row 1 : 1 | Sony | Tokyo | Andy | 120 row 2 : 2 | Creative Labs | Austin | Owen | 100 row 3 : 3 | Hewlett-Packard | Los Angeles | James | 50 row 4 : 4 | Iomega | Beijing | Mary | 200 row 5 : 5 | Fujitsu | Taiwan | John | 130 row 6 : 6 | Winchester | Paris | Robert | 30 <table_name> : Products col : Code | Name | Price | Manufacturer row 1 : 1 | Hard drive | 240 | 5 row 2 : 2 | Memory | 120 | 6 row 3 : 3 | ZIP drive | 150 | 4 row 4 : 4 | Floppy disk | 5 | 6 row 5 : 5 | Monitor | 240 | 1 row 6 : 6 | DVD drive | 180 | 2 row 7 : 7 | CD drive | 90 | 2 row 8 : 8 | Printer | 270 | 3 row 9 : 9 | Toner cartridge | 66 | 3 row 10 : 10 | DVD burner | 180 | 2 row 11 : 11 | DVD drive | 150 | 3
col : avg(T1.price) | Name row 1 : 150.0 | Creative Labs row 2 : 240.0 | Fujitsu row 3 : 162.0 | Hewlett-Packard row 4 : 150.0 | Iomega row 5 : 240.0 | Sony row 6 : 62.5 | Winchester