what is the building id for the apt number suite 645
select building_id from apartments where apt_number = "Suite 645"
what is the bathroom count and bedroom count of the apartment number suite 645?
select bathroom_count, bedroom_count from apartments where apt_number = "Suite 645"
what is the room count in the building 624?
select room_count from apartments where building_id = 624
what is minimum and maximum number of bathrooms and bedrooms of all the apartments?
select min ( bathroom_count ), max ( bathroom_count ), min ( bedroom_count ), max ( bedroom_count ) from apartments
what is the building_id of the apartment apt.908?
select building_id from apartments where apt_number = "Apt. 908"