SQL statment in ACCESS:

Suppose you have several housing companies and the company (SUNHOUSE) is one of them. Every house company has a property and every property has apartments. Suppose you have a list of owners who have owned different apartments for different periods. It is possible that the same apartment bought and sold several times. write SQL statment that show the name(s) of the person (s) who have owned an apartment furthest in house company SUNHOUSE, here is the contract length that is interesting, so if someone has bought or sold apartment several times, each contract should be considered separately.