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: Return the name and number of reservations made for each of the rooms. | rooms : roomid , roomname , beds , bedtype , maxoccupancy , baseprice , decor | reservations : code , room , checkin , checkout , rate , lastname , firstname , adults , kids | reservations.room = rooms.roomid | 

### Response:

select _ , count ( _ ) , _ from _ group by _ | select rooms.roomname , count ( * ) , reservations.room from reservations join rooms on reservations.room = rooms.roomid group by reservations.room