Yardi Systems Interview Question

SQL related Queries Joins, Normalization