Infosys interview question

Complex query of MySQL involving multiple table join.