How many rooms are in the apartment number suite 645?
select count ( * ) from apartments where apt_number = "Suite 645"
What is the building id of apartment Apt 585?
select building_id from apartments where apt_number = "Apt. 585"
What is the minimum and maximum number of bathrooms of all the departments?
select min ( bathroom_count ), max ( bathroom_count ) from apartments