Which reservations were made by DAMIEN TRACHSEL?
select * from reservations where firstname = "DAMIEN" and lastname = "TRACHSEL";
Which one has check in date Sep 21, 2010?
select * from reservations where checkin = "2010-09-21" and firstname = "DAMIEN" and lastname = "TRACHSEL";
Find the number of kids for this reservation.
select kids from reservations where checkin = "2010-09-21" and firstname = "DAMIEN" and lastname = "TRACHSEL";