Yardi Systems interview question

SQL related Queries Joins, Normalization