Hello!  How many different Apartment Type Codes are there?
select count ( apt_type_code ) from apartments
Can you provide me with the most common apartment type code among all of the apartments with at least 1 bathroom?
select apt_type_code from apartments where bathroom_count > = 1 group by apt_type_code order by count ( * ) desc limit 1
Can you list all apartment IDs with "Flat" as the apartment type?
select apt_id from apartments where apt_type_code = 'Flat'
Thank you! Can you update that list to include the building ID for each of those apartment IDs?
select building_id, apt_id from apartments where apt_type_code = 'Flat'