How many different apartment building are there?
select count ( distinct building_id ) from apartment_buildings
How many of those apartment building are managed by Kyle?
select count ( * ) from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id where t1.building_manager = "Kyle"
How many apartment type codes are there?
select count ( distinct apt_type_code ) from apartments
Show the apartment types codes in buildings managed by Kyle?
select t2.apt_type_code from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id where t1.building_manager = "Kyle"
Show the apartment numbers in the buildings managed by Kyle.
select t2.apt_number from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id where t1.building_manager = "Kyle"