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: How many adults stay in the room CONRAD SELBIG checked in on Oct 23, 2010? | rooms : roomid , roomname , beds , bedtype , maxoccupancy , baseprice , decor | reservations : code , room , checkin , checkout , rate , lastname , firstname , adults , kids | reservations.room = rooms.roomid | 

### Response:

select _ from _ where _ | select adults from reservations where checkin = '2010-10-23' and firstname = 'CONRAD' and lastname = 'SELBIG'