Pregunta de entrevista de Yardi Systems

very difficult, Schema based sql questions