Pregunta de entrevista de Yardi Systems

Some sql queries regarding joins