What is the average number of rooms of apartments with type code "Studio"?
SELECT avg(room_count) FROM Apartments WHERE apt_type_code  =  "Studio"
average number of rooms = AVG(room_count); apartments with type code \"Studio\" refers to apt_type_code = \"Studio\";