Yardi Systems interview question

SQL basic questions