CREATE TABLE rooms (roomid TEXT, roomname TEXT, beds DECIMAL, bedtype TEXT, maxoccupancy DECIMAL, baseprice DECIMAL, decor TEXT)
CREATE TABLE reservations (code DECIMAL, room TEXT, checkin TEXT, checkout TEXT, rate DECIMAL, lastname TEXT, firstname TEXT, adults DECIMAL, kids DECIMAL)

How many adults stay in the room CONRAD SELBIG checked in on Oct 23, 2010?
SELECT adults FROM reservations WHERE checkin = "2010-10-23" AND firstname = "CONRAD" AND lastname = "SELBIG"
SELECT "adults" FROM "reservations" WHERE "2010-10-23" = "checkin" AND "CONRAD" = "firstname" AND "SELBIG" = "lastname"