Infosys Interview Question

Complex query of MySQL involving multiple table join.