Write a SQL query

SQL query :



Data model

Apartments (idApartment, #idBuilding, Number, Floor, SurfaceArea)
Buildings (idBuilding, Name,Adress, NbFloors, YearOfConstruction, #idPerson)
Occupants (#idBuilding, #idApartment, #idPerson, YearOfArrival)
Persons (idPerson, Name, Age, Profession)