Yardi Systems interview question

Question on SQL and Advanced SQL