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
apartment with the greatest number of bedrooms refers to MAX(bedroom_count);