CREATE TABLE view_unit_status (apt_id NUMBER, apt_booking_id NUMBER, status_date TIME, available_yn others)
CREATE TABLE apartment_bookings (apt_booking_id NUMBER, apt_id NUMBER, guest_id NUMBER, booking_status_code CLOB, booking_start_date TIME, booking_end_date TIME)
CREATE TABLE guests (guest_id NUMBER, gender_code CLOB, guest_first_name CLOB, guest_last_name CLOB, date_of_birth TIME)
CREATE TABLE apartments (apt_id NUMBER, building_id NUMBER, apt_type_code CLOB, apt_number CLOB, bathroom_count NUMBER, bedroom_count NUMBER, room_count CLOB)
CREATE TABLE apartment_buildings (building_id NUMBER, building_short_name CLOB, building_full_name CLOB, building_description CLOB, building_address CLOB, building_manager CLOB, building_phone CLOB)
CREATE TABLE apartment_facilities (apt_id NUMBER, facility_code CLOB)

Show the apartment type code that has the largest number of total rooms, together with the number of bathrooms and number of bedrooms.
SELECT apt_type_code, bathroom_count, bedroom_count FROM apartments GROUP BY apt_type_code ORDER BY SUM(room_count) DESC LIMIT 1
SELECT "apt_type_code", "bathroom_count", "bedroom_count" FROM "apartments" GROUP BY "apt_type_code" ORDER BY SUM("room_count") DESC FETCH FIRST 1 ROWS ONLY