Yardi Systems interview question

Resume Based Questions, SQL (Joins , Trigger),Oops