Yardi Systems interview question

Multiple questions on Sql queries