For each manufacturer name, what are the names and prices of their most expensive product?
select t1.name, max(t1.price), t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code group by t2.name