text: CREATE TABLE Apartment_Buildings (building_id VARCHAR, building_manager VARCHAR); CREATE TABLE Apartments (apt_type_code VARCHAR, apt_number VARCHAR, building_id VARCHAR) -- Show the apartment type codes and apartment numbers in the buildings managed by "Kyle". SELECT T2.apt_type_code, T2.apt_number FROM Apartment_Buildings AS T1 JOIN Apartments AS T2 ON T1.building_id = T2.building_id WHERE T1.building_manager = "Kyle" CREATE TABLE Apartment_Bookings (booking_status_code VARCHAR) -- Show the booking status code and the corresponding number of bookings. SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code CREATE TABLE Apartments (apt_number VARCHAR, room_count VARCHAR) -- Return all the apartment numbers sorted by the room count in ascending order. SELECT apt_number FROM Apartments ORDER BY room_count CREATE TABLE Apartments (apt_number VARCHAR, bedroom_count VARCHAR) -- Return the apartment number with the largest number of bedrooms. SELECT apt_number FROM Apartments ORDER BY bedroom_count DESC LIMIT 1 CREATE TABLE Apartments (apt_type_code VARCHAR) -- Show the apartment type codes and the corresponding number of apartments sorted by the number of apartments in ascending order. SELECT apt_type_code, COUNT(*) FROM Apartments GROUP BY apt_type_code ORDER BY COUNT(*) CREATE TABLE Apartments (apt_type_code VARCHAR, room_count INTEGER) -- Show the top 3 apartment type codes sorted by the average number of rooms in descending order. SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY AVG(room_count) DESC LIMIT 3