CREATE TABLE Apartment_Bookings (apt_booking_id NUMBER, apt_id NUMBER, guest_id NUMBER, booking_status_code CHAR, booking_start_date DATETIME, booking_end_date DATETIME)
CREATE TABLE Apartments (apt_id NUMBER, building_id NUMBER, apt_type_code CHAR, apt_number CHAR, bathroom_count NUMBER, bedroom_count NUMBER, room_count CHAR)
CREATE TABLE Apartment_Facilities (apt_id NUMBER, facility_code CHAR)
CREATE TABLE View_Unit_Status (apt_id NUMBER, apt_booking_id NUMBER, status_date DATETIME, available_yn BIT)
CREATE TABLE Apartment_Buildings (building_id NUMBER, building_short_name CHAR, building_full_name VARCHAR2, building_description VARCHAR2, building_address VARCHAR2, building_manager VARCHAR2, building_phone VARCHAR2)
CREATE TABLE Guests (guest_id NUMBER, gender_code CHAR, guest_first_name VARCHAR2, guest_last_name VARCHAR2, date_of_birth DATETIME)

How many buildings are managed by 'Kyle'? Return a bar chart grouping by apartment type codes, list y-axis in asc order.
SELECT apt_type_code, COUNT(apt_type_code) FROM Apartment_Buildings AS T1 JOIN Apartments AS T2 ON T1.building_id = T2.building_id WHERE T1.building_manager = "Kyle" GROUP BY apt_type_code ORDER BY COUNT(apt_type_code)
SELECT "apt_type_code", COUNT("apt_type_code") FROM "Apartment_Buildings" "T1" JOIN "Apartments" "T2" ON "T1"."building_id" = "T2"."building_id" WHERE "Kyle" = "T1"."building_manager" GROUP BY "apt_type_code" ORDER BY COUNT("apt_type_code")