Sql Statment Access Suppose Several Housing Companies Company Sunhouse One Every House Co Q43788630
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 hasapartments.
Suppose you have a list of owners who have owned differentapartments for different periods.
It is possible that the same apartment bought and sold severaltimes.
write SQL statment that show the name(s) of the person (s) who haveowned an apartment furthest in house company SUNHOUSE, here is thecontract length that is interesting, so if someone has bought orsold apartment several times, each contract should be consideredseparately.
Expert Answer
Answer to SQL statment in ACCESS: Suppose you have several housing companies and the company (SUNHOUSE) is one of them. Every hous…
OR