Yardi Systems interview question

Very basic SQL based coding