Which reservations were made by CONRAD SELBIG?
select * from reservations where firstname = "CONRAD" and lastname = "SELBIG";
Which one has check in date Oct 23, 2010?
select * from reservations where checkin = "2010-10-23" and firstname = "CONRAD" and lastname = "SELBIG";
Find the number of adults for this reservation.
select adults from reservations where checkin = "2010-10-23" and firstname = "CONRAD" and lastname = "SELBIG";