How many patients in this table?
select count ( patient ) from stay
Find the patient who most recently stayed in room 112?
select patient from stay where room = 112 order by staystart desc limit 1
How many rooms in this table?
select count ( distinct room ) from stay