Yardi Systems interview question

Some sql queries regarding joins