Yardi Systems interview question

Pattern question SQL queries on join, group by, update clause. Questions from Resume