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

Return the number of kids for the room reserved and checked in by DAMIEN TRACHSEL on Sep 21, 2010.
SELECT kids FROM reservations WHERE checkin = "2010-09-21" AND firstname = "DAMIEN" AND lastname = "TRACHSEL"
SELECT "kids" FROM "reservations" WHERE "2010-09-21" = "checkin" AND "DAMIEN" = "firstname" AND "TRACHSEL" = "lastname"