question: Select the average price of each manufacturer's products, showing the manufacturer's name.
#1 return manufacturers 
#2 return products of #1 
#3 return prices of #2 
#4 return the  average of #3 for each #1 
#5 return the  names of #1 
#6 return #4 ,  #5