how many times does ROY SWEAZY has reserved a room
select count ( * ) from reservations where firstname = "ROY" and lastname = "SWEAZY"
ok,show the count of all room
select count ( distinct room ) from reservations
show the count of all adults and kids
select count ( adults ), count ( kids ) from reservations
find the check in and out for the code 10105
select checkin, checkout from reservations where code = 10105