Yardi Systems interview question

Mostly about SQL