Yardi Systems interview question

SQL , joins , view , Constraints , etc