How many adults stay in the room CONRAD SELBIG checked in on Oct 23, 2010?
CREATE TABLE rooms (
    roomid text,
    roomname text,
    beds number,
    bedtype text,
    maxoccupancy number,
    baseprice number,
    decor text
)

CREATE TABLE reservations (
    code number,
    room text,
    checkin text,
    checkout text,
    rate number,
    lastname text,
    firstname text,
    adults number,
    kids number
)
SELECT adults FROM reservations WHERE checkin = "2010-10-23" AND firstname = "CONRAD" AND lastname = "SELBIG"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many adults stay in the room CONRAD SELBIG checked in on Oct 23, 2010? ### Input: CREATE TABLE rooms (
    roomid text,
    roomname text,
    beds number,
    bedtype text,
    maxoccupancy number,
    baseprice number,
    decor text
)

CREATE TABLE reservations (
    code number,
    room text,
    checkin text,
    checkout text,
    rate number,
    lastname text,
    firstname text,
    adults number,
    kids number
) ### Response: SELECT adults FROM reservations WHERE checkin = "2010-10-23" AND firstname = "CONRAD" AND lastname = "SELBIG"