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: Find all manufacturers' names and their headquarters, sorted by the ones with highest revenue first. | manufacturers : code , name , headquarter , founder , revenue | products : code , name , price , manufacturer | products.manufacturer = manufacturers.code | 

### Response:

select _ from _ order by _ desc | select name , headquarter from manufacturers order by revenue desc