Pregunta de entrevista de Infosys

Complex query of MySQL involving multiple table join.