Yardi Systems interview question

Sql queries, changing db relationship schema