Yardi Systems interview question

Complex sql queries