Schema: CREATE TABLE Apartments (room_count INTEGER, apt_type_code VARCHAR)
Question: What is the average number of rooms of apartments with type code "Studio"?
SQL: SELECT AVG(room_count) FROM Apartments WHERE apt_type_code = "Studio"