Task: Text to Code
Input (English): What are the top three apartment types in terms of the average room count? Give me the
Output (English): SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY avg(room_count) DESC LIMIT 3