Yardi Systems Interview Question

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