Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: Select the name of each manufacturer along with the name and price of its most expensive product. | manufacturers : code , name , headquarter , founder , revenue | products : code , name , price , manufacturer | products.manufacturer = manufacturers.code | 

### Response:

select _ , max ( _ ) , _ from _ group by _ | select products.name , max ( products.price ) , manufacturers.name from products join manufacturers on products.manufacturer = manufacturers.code group by manufacturers.name