Return each apartment type code along with the maximum and minimum number of rooms among each type.
CREATE TABLE apartment_facilities (
    apt_id number,
    facility_code text
)

CREATE TABLE apartment_buildings (
    building_id number,
    building_short_name text,
    building_full_name text,
    building_description text,
    building_address text,
    building_manager text,
    building_phone text
)

CREATE TABLE guests (
    guest_id number,
    gender_code text,
    guest_first_name text,
    guest_last_name text,
    date_of_birth time
)

CREATE TABLE view_unit_status (
    apt_id number,
    apt_booking_id number,
    status_date time,
    available_yn others
)

CREATE TABLE apartments (
    apt_id number,
    building_id number,
    apt_type_code text,
    apt_number text,
    bathroom_count number,
    bedroom_count number,
    room_count text
)

CREATE TABLE apartment_bookings (
    apt_booking_id number,
    apt_id number,
    guest_id number,
    booking_status_code text,
    booking_start_date time,
    booking_end_date time
)
SELECT apt_type_code, MAX(room_count), MIN(room_count) FROM apartments GROUP BY apt_type_code
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Return each apartment type code along with the maximum and minimum number of rooms among each type. ### Input: CREATE TABLE apartment_facilities (
    apt_id number,
    facility_code text
)

CREATE TABLE apartment_buildings (
    building_id number,
    building_short_name text,
    building_full_name text,
    building_description text,
    building_address text,
    building_manager text,
    building_phone text
)

CREATE TABLE guests (
    guest_id number,
    gender_code text,
    guest_first_name text,
    guest_last_name text,
    date_of_birth time
)

CREATE TABLE view_unit_status (
    apt_id number,
    apt_booking_id number,
    status_date time,
    available_yn others
)

CREATE TABLE apartments (
    apt_id number,
    building_id number,
    apt_type_code text,
    apt_number text,
    bathroom_count number,
    bedroom_count number,
    room_count text
)

CREATE TABLE apartment_bookings (
    apt_booking_id number,
    apt_id number,
    guest_id number,
    booking_status_code text,
    booking_start_date time,
    booking_end_date time
) ### Response: SELECT apt_type_code, MAX(room_count), MIN(room_count) FROM apartments GROUP BY apt_type_code