Yardi Systems interview question

Aggregrate Functions, Set Operators, Joins