For each manufacturer name, what are the names and prices of their most expensive product?
return manufacturers ;return products of #1 ;return prices of #2 ;return #2 where #3 is the  highest for each #1 ;return names of #4 ;return prices of #4 ;return #5 ,  #6
['select', 'project', 'project', 'group', 'project', 'project', 'union']