What is the number of the apartment with the greatest number of bedrooms?
select apt_number from apartments order by bedroom_count desc limit 1
What is the number of the apartment with the least number of bedrooms?
select apt_number from apartments order by bedroom_count limit 1
What is the apartment type code of the apartment with the greatest number of bathrooms?
select apt_type_code from apartments order by bathroom_count desc limit 1
How many rooms does that apartment have, and what is the number of that apartment?
select room_count, apt_number from apartments order by bathroom_count desc limit 1