Find the average room count of the apartments that have the "Studio" type code.
SELECT avg(room_count) FROM Apartments WHERE apt_type_code  =  "Studio"
average room count = AVG(room_count); apartments with 'Studio' type code refers to apt_type_code = 'Studio';