Yardi Systems interview question

SQL joins , constraints, alias ,top command, etc.