what is the average of rates?
select avg ( rate ) from reservations
show me a list of check outs?
select checkout from reservations
show me a list of check in?
select checkin from reservations
how many adults stay in the room contad selbig checked in on oct 23, 2010?
select count ( adults ) from reservations where checkin = "2010-10-23" and firstname = "CONRAD" and lastname = "SELBIG"