Yardi Systems interview question

write SQL queries, specifically involving JOINs, triggers, or stored procedures.