Yardi Systems Interview Question

They asked more about SQL. How to write queries using joints and all